| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trying to remove phone: from the column = [phone: 4253331212]
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
trying to remove phone: from the column = [phone: 4253331212]
Fast option:
1. Add a new column next to your existing column. For the sake of this example, I'll assume your data is in Column A, starting in cell A2 2. In the first blank cell next to your first number (B2), enter the formula: =right(A2,len(A2)-6) if that is too many or two few digits, change the value from 6 to 5 or 7 or whatever you need autofill that formula down the whole column Copy that column, then "paste special"/ values over itself to get rid of the formulas Delete the original column of data. HTH, Keith "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 |
|
#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 |
| Reply |
| 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) | |||
Hybrid Mode
