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.