| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Replace
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| Find and replace | New Users to Excel | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| find and replace | Excel Discussion (Misc queries) | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Hybrid Mode
