Posted to microsoft.public.excel.worksheet.functions

[email protected] chiuinggum@hotmail.com is offline

external usenet poster

Posts: 5

how to remove dashes

I have a list of 500 part number with dashes in between. Example 1234-56-789.
How do able to remove the dashes to make it 123456789?

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
Replace dashes	Wanna Learn	Excel Discussion (Misc queries)	6	January 24th 07 05:40 PM
What are dashes for	WLMPilot	Excel Discussion (Misc queries)	3	November 27th 06 11:03 PM
Remove Dashes from Social Security Numbers	catrose	Excel Worksheet Functions	4	September 7th 06 04:20 PM
remove the ( ) & dashes from column of phone #	alvie	Excel Worksheet Functions	2	July 2nd 06 04:32 PM
Dashes in Functions	LPS	Excel Discussion (Misc queries)	2	January 19th 06 02:38 PM

All times are GMT +1. The time now is 05:52 PM.

About Us

"It's about Microsoft Excel"