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

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

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

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