| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trying to remove phone: from the column = [phone: 4253331212]
EditReplace 2 times.
Replace what: [phone: include the <space Replace with nothing Replace what: ] Replace with nothing. Gord Dibben MS Excel MVP On Tue, 1 Dec 2009 11:08:01 -0800, Importing iPhone Contacts wrote: got a full column with 500 cells that contain the name[phone:] how to I clear the {phone:] from all cells in the column? Thx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change Phone: 8153381667 to Phone: 815-338-1667 | New Users to Excel | |||
| How do you remove phone format???? | Excel Discussion (Misc queries) | |||
| Remove dashes from phone numbers in a spreadsheet | Excel Worksheet Functions | |||
| remove the ( ) & dashes from column of phone # | Excel Worksheet Functions | |||
| How can I cross reference phone numbers with existing phone numbe. | Excel Discussion (Misc queries) | |||
Threaded Mode
