Posted to microsoft.public.excel.misc

Dashman

external usenet poster

Posts: 5

Eliminating the dashes

I have a column of part numbers that have dashes in them, such as 101-500 and
I want an easy way to eliminate the dash and keep the remaoning value without
edit easch individual cell ie. F2 backspace and then delete the dash. I have
tried doing a macro but I am not familiar with how to do them.

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
#N/A and eliminating it.	Ted	Excel Discussion (Misc queries)	2	April 24th 07 05:26 PM
What are dashes for	WLMPilot	Excel Discussion (Misc queries)	3	November 27th 06 11:03 PM
eliminating the 0 in DIV/0	teacher1	Excel Discussion (Misc queries)	11	September 13th 06 09:28 PM
Eliminating #N/A	Mike	Excel Worksheet Functions	4	December 14th 05 07:34 PM
Eliminating every 25th row	Lram	Excel Worksheet Functions	5	October 16th 05 11:07 PM

All times are GMT +1. The time now is 04:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us