Taking out the first 3 numbers

Ricker

New Member
Joined
Nov 28, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

cfree36

Board Regular
Joined
Oct 5, 2005
Messages
175
=right(D1,7)

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

wwbwb

Well-known Member
Joined
Oct 20, 2003
Messages
513
Try in e1

=right(d1,7)

where d1 is the phone # then copy down
 

Watch MrExcel Video

Forum statistics

Threads
1,118,451
Messages
5,572,201
Members
412,447
Latest member
immy
Top