insert a space in a phone #. change (123)456-7890 to (123) 456-78

  • Thread starter Thread starter Guest
  • Start date Start date
Go to edit - replace
find what : )
replace with: ) [insert a space after ) ]
click on replace all
 
worked like a charm, thx,leo

N Harkawat said:
Go to edit - replace
find what : )
replace with: ) [insert a space after ) ]
click on replace all
Click to expand...
 
Method 1:

Enter it as 1234567890
Format/Cells/Special Phone Number
or
Format/Cells/Custom Type: (###) ###-####

Method 2 -- if the data is already entered as Text:

Use a helper column. If your original data starts in row 2, insert the
formula:

=SUBSTITUTE(A2,")",") ")

in some cell in the helper column, and copy/drag the formula down as far as
necessary.


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Phone Numbers in Excel 2007 Help 15
Remove Specific Text - HELP! 6
Formula to extract digits from a text string? 7
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
How to filter unique entires in a column when differnet entires in 13
Changing the format of a phone number 2
display repeating row information in columns 1
Text to columns and comma delimited text 5

Back
Top