Thread: Find & Replace
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Find & Replace

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

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

HTH,
Paul


"JAD" wrote in message
...
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