Data Visability

[Bandogge]

Okay, I exported contacts from a CRM database. In one of the columns it reads

Phone No.:888-888-8888

When I go to any cells in this column all that appears in the formula bar above is Phone No.:

For some reason the number is not there, nor can I separate/isolate the actual number from the words Phone No.: so that I can remap the field to another CRM.

 

[Bandogge]

will do, thanks for the help, really appreciated, I appreciate all for their input, thanks so much, saved me hours or tinkering or retyping.