LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Removing parentheses in a phone number

On Mar 22, 1:17 pm, Helmut Weber wrote:
Hi everybody,

the question is: What is the question?

The perfect solution would be "555-555-5555".

As simple as that. ;-)

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"


Yes this is what I was looking for, 3 digits dash 3 digits dash 4
digits.
Tim's solution worked for me. Thanks for everyones input.

It seems with coding eveyone has a different approach, but the results
are the same.



 
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
Removing Hyphens in phone list??? TotallyConfused Excel Discussion (Misc queries) 4 March 2nd 08 03:11 AM
number in parentheses Mike Excel Discussion (Misc queries) 6 May 10th 07 10:47 PM
How do I produce a number in parentheses? CLR Excel Discussion (Misc queries) 5 June 8th 06 06:17 AM
removing dashes from phone numbers Brad Excel Discussion (Misc queries) 3 May 24th 05 03:27 PM
Removing parentheses Brett Excel Worksheet Functions 6 February 9th 05 04:46 PM


All times are GMT +1. The time now is 07:12 PM.

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

About Us

"It's about Microsoft Excel"