Taking out the first 3 numbers

[Ricker]

Hello all,

Having a problem with numbers. I have a spreadsheet with 4 columns on it and in the last one Col D, I have listings of phone numbers as 10 digits. I would like to remove the first 3 numbers in this case would be an area code. Can anyone help with this one? I would do this manually but there is no chance to learn something new and there are over 8k numbers

Rich

 

[cfree36]

=right(D1,7)

Actually keeps the last 7 (therefore getting rid of the first 3)

 

[wwbwb]

Try in e1

=right(d1,7)

where d1 is the phone # then copy down

 

[Pekkavee]

cfree36 is the quickiest to type

Pekka