Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
leo
 
Posts: n/a
Default insert a space in a phone #. change (123)456-7890 to (123) 456-78


  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

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


"leo" wrote in message
...



  #3   Report Post  
N Harkawat
 
Posts: n/a
Default

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

"leo" wrote in message
...



  #4   Report Post  
Jason Morin
 
Posts: n/a
Default

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

HTH
Jason
Atlanta, GA

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

.

  #5   Report Post  
leo
 
Posts: n/a
Default

works great, thx,leo

"Jason Morin" wrote:

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

HTH
Jason
Atlanta, GA

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

.




  #6   Report Post  
leo
 
Posts: n/a
Default

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   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
change the default word in the insert comment option in excel excel Setting up and Configuration of Excel 1 December 28th 04 03:50 PM
change the default word in the insert comment option in excel excel Setting up and Configuration of Excel 2 December 24th 04 01:51 PM
HELP - I need to change space delimited to comma? Mayer Excel Discussion (Misc queries) 1 December 18th 04 07:21 PM
How do I change the default color of the tag for insert c... [email protected] Excel Discussion (Misc queries) 1 December 18th 04 12:01 AM


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"