trying to remove phone: from the column = [phone: 4253331212]

  • Thread starter Thread starter Importing iPhone Contacts
  • Start date Start date
I

Importing iPhone Contacts

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
 
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
 
Back
Top