How to remove 1 from a number eg: 19254582300

Joined
Feb 28, 2008
Messages
1
Reaction score
0
How can i use excell to remove the number 1 from a list of data that consists of phone numbers in one coloumn.

eg: 1 925 325 2008 into 925 325 2008 only with the number 1 removed.

I need to do this with muliple line items at once.

I have a windows xp proffesional operating system and excell proffessional 2003.

your input is greatly appreciated.

Thank you
 
Back
Top