Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find replace the 1st character in a cell
Hi
I have hundreds of contact numbers that I have imported into XL 07 from MS BCM07. The numbers come in with the area code in brackets followed by the number e.g. (02) 1234 5678 I want the number to look like this example: 0212345678 Of course, the area code differs depending on the contact's location e.g. (02),(03), (07),(08) I can do a find & replace edit on the brackets & spaces between the numbers however when I remove these, the "0" drops off the beginning of the number e.g. 212345678 Is there a formula, find/replace or other solution? -- TIA Pete WIN XP SP2, XL07, OL & BCM 07, 1 gig ram |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find a replace character question | Excel Discussion (Misc queries) | |||
find a character and replace with a command in Excel | Excel Discussion (Misc queries) | |||
How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) | |||
How to remove or replace a carriage return character in a cell? | Excel Discussion (Misc queries) | |||
Search and replace character with |
Excel Discussion (Misc queries) |