take SOME info from one coloumn and place it in another?

Hi everyone,

I am not that good with excel but I use it to convert data to a MySQL database. Anyway my dilemma is this:

I have one column A which has comic book information in the following format:
Action Comics #1
Action Comics #120
Action Comics #321
etc...

I need to split this column and make it into 2 separate columns. One by title and the other stores the issue number:
Column A Column B
Action Comics 1
Action Comics 120
Action Comics 321

Is it possible to do this automatically to save time and energy? We have over 5000 rows and it would be very tedious to have to sperate the data by hand.

I appreciate any advice or help.

Thanks in advance.

SC

Originally Posted by suttercain

Hi everyone,

I am not that good with excel but I use it to convert data to a MySQL database. Anyway my dilemma is this:

I have one column A which has comic book information in the following format:
Action Comics #1
Action Comics #120
Action Comics #321
etc...

I need to split this column and make it into 2 separate columns. One by title and the other stores the issue number:
Column A Column B
Action Comics 1
Action Comics 120
Action Comics 321

Is it possible to do this automatically to save time and energy? We have over 5000 rows and it would be very tedious to have to sperate the data by hand.

I appreciate any advice or help.

Thanks in advance.

SC

Hi

Select your column.Select the menu Data/Convert/Delimited Next/Space and OK.
From John Carpenter.

Hi John Carpenter

I selected the column, selected the data menu but there is no convert option to select. I am running Excel 2002, I don't know if that makes a difference?

Ah... found it. It was Data/Text to Columns

But thanks for getting me on the right path.