Truncate column of social security numbers to the first four digits.
B bj Jun 1, 2005 #2 I assume you want to have just the first four digits try =LEFT(SUBSTITUTE(A1,"-",""),4)
D Dave Peterson Jun 1, 2005 #3 Are they really numbers just formatted as SSN's? =INT(A1/100000) Or did you enter them as text? 123-45-6789 =substitute(left(a1,5),"-","")
Are they really numbers just formatted as SSN's? =INT(A1/100000) Or did you enter them as text? 123-45-6789 =substitute(left(a1,5),"-","")
