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