Home |
Search |
Today's Posts |
#1
|
|||
|
|||
truncate ssn to first four digits
Truncate column of social security numbers to the first four digits.
|
#2
|
|||
|
|||
I assume you want to have just the first four digits
try =LEFT(SUBSTITUTE(A1,"-",""),4) "DonJackson" wrote: Truncate column of social security numbers to the first four digits. |
#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),"-","") DonJackson wrote: Truncate column of social security numbers to the first four digits. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by last 2 digits | Excel Worksheet Functions | |||
15 digits??? | Excel Discussion (Misc queries) | |||
Least number of digits in Y-axis labels | Charts and Charting in Excel | |||
How do I format cells to a specific number of digits? | Excel Discussion (Misc queries) | |||
Using a IF formula, I would like to drop the 2 digits in front of. | Excel Discussion (Misc queries) |