Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert a space in a phone #. change (123)456-7890 to (123) 456-78
|
#2
|
|||
|
|||
Go to edit - replace
find what : ) replace with: ) [insert a space after ) ] click on replace all "leo" wrote in message ... |
#3
|
|||
|
|||
And a formula based approach
=MID(A1,1,5)&" "&MID(A1,6,10) "leo" wrote in message ... |
#4
|
|||
|
|||
=SUBSTITUTE(A1,")",") ")
HTH Jason Atlanta, GA -----Original Message----- . |
#5
|
|||
|
|||
works great, thx,leo
"Jason Morin" wrote: =SUBSTITUTE(A1,")",") ") HTH Jason Atlanta, GA -----Original Message----- . |
#6
|
|||
|
|||
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 ... |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenging Charting | Charts and Charting in Excel | |||
change the default word in the insert comment option in excel | Setting up and Configuration of Excel | |||
change the default word in the insert comment option in excel | Setting up and Configuration of Excel | |||
HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) | |||
How do I change the default color of the tag for insert c... | Excel Discussion (Misc queries) |