ExcelBanter - truncate ssn to first four digits

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - truncate ssn to first four digits (https://www.excelbanter.com/excel-discussion-misc-queries/28561-truncate-ssn-first-four-digits.html)

DonJackson

truncate ssn to first four digits

Truncate column of social security numbers to the first four digits.

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.

Dave Peterson

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

All times are GMT +1. The time now is 09:05 PM.