| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting single column data into two
I've got a worksheet with one long column: A 165 Archivists and curators (252) 137 Art, drama, and music teachers (2235) 194 Artists, performers, and related workers, n.e.c. (328, 329) 199 Athletes (34) 074 Atmospheric and space scientists (1846) 183 Authors (34) 078 Biological and life scientists (1854) 114 Biological science teachers (2213) 135 Business, commerce, and marketing teachers (2233) 048 Chemical engineers (1626) 115 Chemistry teachers (2214) and so on. I know it's possible to split it so I end up with the numbers (165, 137, etc.) in column A and their corresponding categories in column B, but I have no idea where to start! Is anybody familiar with a function that would do this? Thanks much for any help available! -- loopkid1 ------------------------------------------------------------------------ loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729 View this thread: http://www.excelforum.com/showthread...hreadid=506812 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting single column data into two
Data TextToColumns FixedWidth.........set the column break where you wish.
Vaya con Dios, Chuck, CABGx3 "loopkid1" wrote: I've got a worksheet with one long column: A 165 Archivists and curators (252) 137 Art, drama, and music teachers (2235) 194 Artists, performers, and related workers, n.e.c. (328, 329) 199 Athletes (34) 074 Atmospheric and space scientists (1846) 183 Authors (34) 078 Biological and life scientists (1854) 114 Biological science teachers (2213) 135 Business, commerce, and marketing teachers (2233) 048 Chemical engineers (1626) 115 Chemistry teachers (2214) and so on. I know it's possible to split it so I end up with the numbers (165, 137, etc.) in column A and their corresponding categories in column B, but I have no idea where to start! Is anybody familiar with a function that would do this? Thanks much for any help available! -- loopkid1 ------------------------------------------------------------------------ loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729 View this thread: http://www.excelforum.com/showthread...hreadid=506812 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting single column data into two
That seems to have done it. Thanks much! -- loopkid1 ------------------------------------------------------------------------ loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729 View this thread: http://www.excelforum.com/showthread...hreadid=506812 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting single column data into two
You're welcome.........happy to be of help
Vaya con Dios, Chuck, CABGx3 "loopkid1" wrote: That seems to have done it. Thanks much! -- loopkid1 ------------------------------------------------------------------------ loopkid1's Profile: http://www.excelforum.com/member.php...o&userid=21729 View this thread: http://www.excelforum.com/showthread...hreadid=506812 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print a single column of data in two columns on one page | Excel Discussion (Misc queries) | |||
| I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
| how to convert multiple columns of data into one single column? | Excel Worksheet Functions | |||
Linear Mode
