Have you checked out Data - Text to Columns... To split out your numbers?
--
HTH...

Jim Thomlinson


"Kyle" wrote:

I have a column of data with numbers relating to specific industries. Each
row corresponds to an individual and their affiliated industries. Some cells
contain 1 number and some contain several (separated by commas). I would like
to break this column apart into each individual industry for separate
columns. The corresponding person would have an x in the column that refers
to the industry they relate to. I have a separate sheet for what each code
(number) means. HELP!