Find & Replace

G

Guest

I have a list of phone numbers that start with the number 9 then 1. After
the 1, you have the typical area code and number. Assuming I can use the
Find and Replace feature, how do I find and remove the number 9 and 1 from
the number sequence? I know how to use the replace command when substituting
a value with a new value but not earasing or deleting a part of a string. Any
help would be appreciated. Thank You, JAD
 
P

PCLIVE

If all the numbers begin with "91", you could use something like this.

=RIGHT(A1,LEN(A1)-2)

HTH,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Find and Replace in Excel 2
find replace the 1st character in a cell 2
Find & Replace 3
Use of Wildcard characters with replace 2
Find/Replace hundreds of values 9
Find & Replace Special characters with numbers 2
Find / Replace 3
Find and Replace only the first character 3

Top