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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - insert a space in a phone #. change (123)456-7890 to (123) 456-78 (https://www.excelbanter.com/excel-worksheet-functions/9259-insert-space-phone-change-123-456-7890-123-456-78-a.html)

leo

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

N Harkawat

Go to edit - replace
find what : )
replace with: ) [insert a space after ) ]
click on replace all

"leo" wrote in message
...

N Harkawat

And a formula based approach
=MID(A1,1,5)&" "&MID(A1,6,10)

"leo" wrote in message
...

Jason Morin

=SUBSTITUTE(A1,")",") ")

HTH
Jason
Atlanta, GA

-----Original Message-----

.

leo

works great, thx,leo

"Jason Morin" wrote:

=SUBSTITUTE(A1,")",") ")

HTH
Jason
Atlanta, GA

-----Original Message-----

.

leo

worked like a charm, thx,leo

"N Harkawat" wrote:

Go to edit - replace
find what : )
replace with: ) [insert a space after ) ]
click on replace all

"leo" wrote in message
...

Ron Rosenfeld

On Fri, 14 Jan 2005 12:55:06 -0800, leo wrote:

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

All times are GMT +1. The time now is 06:31 AM.