Posted to microsoft.public.excel.misc

Blaine Davidson Blaine Davidson is offline

external usenet poster

Posts: 1

Excel Question from a beginner

I've got a collumn of several hundred phone numbers like the following example.

Number
(509) 764-2214
(208) 989-6140
(586) 764-4606
(253) 862-2200
(843) 821-9941

I need to take out the parentheses and hyphens, ideally without having to
manually do it. Is there a tool, functionality or process which will take
these out for me?

Thanks kindly for your time!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Beginner in excel	Sarah	Excel Discussion (Misc queries)	7	May 28th 07 06:51 PM
Excel Beginner,	TSNS	Excel Worksheet Functions	3	May 14th 07 03:00 AM
Beginner Question	Bernie	Charts and Charting in Excel	0	February 13th 07 04:31 PM
Beginner question!	Pat	Excel Discussion (Misc queries)	3	August 7th 06 09:19 AM
Beginner question	Tom.	Excel Discussion (Misc queries)	1	April 24th 06 06:08 AM

All times are GMT +1. The time now is 11:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us