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

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

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