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

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


"leo" <[email protected]> wrote in message
news:[email protected]...
>

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

"leo" <[email protected]> wrote in message
news:[email protected]...
>

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

HTH
Jason
Atlanta, GA

>-----Original Message-----
>
>.
>

works great, thx,leo

"Jason Morin" wrote:

> =SUBSTITUTE(A1,")",") ")
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >
> >.
> >
>

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" <[email protected]> wrote in message
> news:[email protected]...
> >
>
>
>

On Fri, 14 Jan 2005 12:55:06 -0800, leo <[email protected]> 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