Delete numbers

[ptrifile]

I have a spreadsheet that lists about 50000 SS #'s and I want to delete the last 2 numbers off of every record...what is the easiest way to go about this?

Thanks!

Paul

 

[EBGreen]

Do you need a quick one time solution?

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[SkipVought]

Hi,

Data/text to columns... Fixed width -- do not import the last 2 characters.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[macropod]

Skip's solution works fine if the numbers are all the same length. If they're not, you could use a formula like:
=LEFT(A1,LEN(A1)-2)
and copy down all 50K rows.

Might take a while to recalc, though.

Cheers
PS: Although SS#s might nominally be the same length, Excel drops any leading 0s from the values it stores.