Separate 5digits by inserting -

Posted to microsoft.public.excel.worksheet.functions

Faio

Posts: n/a

Separate 5digits by inserting -

I have a column containing codes and I wish to separate the first digit from
the rest by inserting a hyphen.
E.g 40000 to be 4-0000, 40001 to 4-0001.

Any suggestions rather than going thru a list of more than 1000s?

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
Separate first and second name in one cell into separate cells.	Dwight in Georgia	Excel Discussion (Misc queries)	3	January 25th 06 09:09 PM
Open Excel files in separate sessions, not just separate windows?	Bob at Dexia Design	Excel Discussion (Misc queries)	1	October 18th 05 05:46 PM
Separate Groups by Inserting Lines	ConfusedNHouston	Excel Discussion (Misc queries)	2	October 17th 05 03:49 PM
Open separate window	Robbin	Excel Worksheet Functions	2	September 1st 05 01:03 PM
Separate first and second name in one cell into separate cells.	Gary's Student	Excel Discussion (Misc queries)	0	April 27th 05 11:11 PM

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

Menu

About Us