Search and replace

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

I am trying to change data entered with an apostrophe ("'")
which charaterize d the data as text to a numerical entry.
I can not get search and replace to find the apostrophe and
replace it w/ nothing. I wish to do this so I can format
the column as phone numbers.

Summary
Change '8001234567 displayed as 8001234567
to 8001234567 displayed as (800) 123-4567
using search and replace!
 
You can quickly convert all your cells by copying an open
cell, selecting the data, and edit > paste special > add.
Then custom format the cells (Format > Cells > Number Tab)
as Special and select Phone Number.

HTH
Jason
Atlanta, GA
 
One way without S&R:

Choose a column of data. Choose Data/Text to Columns... Click Next,
Next, Finish.

Format with Format/Cells/Number/Special/Phone Number
 
Back
Top