L
loopkid1
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 th
numbers (165, 137, etc.) in column A and their corresponding categorie
in column B, but I have no idea where to start! Is anybody familia
with a function that would do this? Thanks much for any hel
available
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 th
numbers (165, 137, etc.) in column A and their corresponding categorie
in column B, but I have no idea where to start! Is anybody familia
with a function that would do this? Thanks much for any hel
available