Posts: n/a

Need to remove hyphen in group of #s

I have a list of numbers as shown
12345-67
12354-58
15454-54
21544-54
I need a formula/macro or something that will allow me to remove the
hyphen.
1234567
1235458
1545454
2154454
Any ideas would be appreciated.
Lakedawgs

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
Can't group pivot table items by month in Excel	scott_ensley	Excel Discussion (Misc queries)	1	February 1st 05 08:41 PM
Subtotal of Subtotal displays Grand Total in wrong row	Thomas Born	Excel Worksheet Functions	5	January 6th 05 01:46 PM
Remove link fr a column of entries	Rasoul Khoshravan Azar	Excel Discussion (Misc queries)	1	December 18th 04 10:51 PM
copy group of cells to another group of cells using "IF" in third	Chuckak	Excel Worksheet Functions	2	November 10th 04 06:04 PM
Group by count formula	nobrabbit	Excel Worksheet Functions	1	November 7th 04 09:10 PM

All times are GMT +1. The time now is 10:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us