N
N Harkawat
Go to edit - replace
find what : )
replace with: ) [insert a space after ) ]
click on replace all
find what : )
replace with: ) [insert a space after ) ]
click on replace all
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
insert a space in a phone #. change (123)456-7890 to (123) 456-78
N
N Harkawat
And a formula based approach
=MID(A1,1,5)&" "&MID(A1,6,10)
=MID(A1,1,5)&" "&MID(A1,6,10)
J
Jason Morin
=SUBSTITUTE(A1,")",") ")
HTH
Jason
Atlanta, GA
HTH
Jason
Atlanta, GA
L
leo
works great, thx,leo
Jason Morin said:=SUBSTITUTE(A1,")",") ")
HTH
Jason
Atlanta, GA
L
leo
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
R
Ron Rosenfeld
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
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