| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting fields from commas
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Splitting fields from commas
Ron, that did exactly what I was looking for! Thanks so much, I reall appreciate the help! 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help splitting text entries with commas | Excel Discussion (Misc queries) | |||
| Splitting data in a single cell that is seperated by commas, then moving to make individual rows | Excel Discussion (Misc queries) | |||
| Splitting text strings along commas. | Excel Discussion (Misc queries) | |||
| splitting fields | Excel Discussion (Misc queries) | |||
| Splitting fields from commas | Excel Programming | |||
Linear Mode
