C
canadianadmin
Hello I have a spreadsheet the has columns for phone numbers in it.
The Phone numbers have been entered manually and have all differen
formats
such as (555)123-1234 or 555-123-1234
I need to delete all of the text so that just the numbers are left s
it looks like 5551231234, so I can upload the column into my cel
phone. Would there be an easy way of doing this with out manuall
changing each entry I have over 2500 phone numbers I have to do thi
to.
I try the Format Painter, and Formatting the Cells but it didn't wor
for me.
I am running Microsoft Office For OS X, and any help would be greatl
appreciated
Thank
The Phone numbers have been entered manually and have all differen
formats
such as (555)123-1234 or 555-123-1234
I need to delete all of the text so that just the numbers are left s
it looks like 5551231234, so I can upload the column into my cel
phone. Would there be an easy way of doing this with out manuall
changing each entry I have over 2500 phone numbers I have to do thi
to.
I try the Format Painter, and Formatting the Cells but it didn't wor
for me.
I am running Microsoft Office For OS X, and any help would be greatl
appreciated
Thank