Posted to microsoft.public.excel.programming

BerkshireGuy BerkshireGuy is offline

external usenet poster

Posts: 6

Parsing into different sheets

I have rows that look like this

20050901 2343;3432
20060823 2232;2321
20050401 2322;4434

I want to parse the values into a separate sheet.

New sheet should look like:

Year Code
-------------------------
2005 2343
2005 3432
2006 2232
2006 2321
2005 2322
2005 4434

Any help would be appreciated.

Thanks

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
Parsing	Saxman[_2_]	Excel Discussion (Misc queries)	3	July 30th 07 04:36 PM
Parsing data into seperate sheets	BerkshireGuy	Excel Programming	2	January 19th 07 12:24 AM
Instead of Parsing	Krish	Excel Discussion (Misc queries)	1	November 4th 06 08:32 PM
Parsing a name	Budget Programmer	Excel Programming	2	August 19th 06 05:13 AM
Parsing help	Richard[_12_]	Excel Programming	0	July 27th 03 12:50 PM

All times are GMT +1. The time now is 10:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us