I'm not sure if this belongs here or in the Functions forum, so pleas
just redirect me if I've erred!
I've got a sizable list of occupational categories (Legal, Government
etc.), however many fields contain more than one:
*Occupation*
Accounting
Accounting
Accounting, Government
Administrative
Administrative, Government, Legal
Administrative, Legal
I need to create subsequent columns, *Occupation2* , *Occupation3*
etc., and somehow split the fields in the *Occupation* column at th
commas, and distribute the words horizontally into the next columns.
I'm completely stumped, can anyone here help? Thanks!
D
--
loopkid
-----------------------------------------------------------------------
loopkid1's Profile:
http://www.excelforum.com/member.php...fo&userid=2172
View this thread:
http://www.excelforum.com/showthread.php?threadid=38135