Text to Column with Exceptions

[willowonyx]

I need serious help with the text to column feature. I have over 4,000 rows of data that has one column that contains all kinds of data that is seperated by commas. If I wanted each piece of data seperated by the commas in a different column that would be easy, but there is a "set" of data within the data that I want to have it's own column and then all the other data can have it own column. If you think you can help, please respond and I can provide more info if needed.

So, in one row I have something like this:

Female, 10/28/70, age 39, COB:USA, 11/02-Oceania, 8/04-Okinawa Japan, 7/09-San Ramon, Jaco Beach CR, 9/10-Jamaica, 10/10-St. Martin, likes fishing, parties all the time, takes medicine, likes computers.

I need the gender, date of birth, age, and COB in seperate columns. But then I need to have 11/02-Oceania through 10/10-St. Martin in one column, and then all the other data after seperated by comma's in seperate columns. So, the dates and countries need to be the only thing together in one column.

Hopefully that makes sense. Is this possible with a macro or something? Each row will have different answers or data.

[martinleyland]

Why don't you comma-separate it all into individual columns, then join up (use CONCATENATE() function) some of it again afterwards?

[willowonyx]

Why don't you comma-separate it all into individual columns, then join up (use CONCATENATE() function) some of it again afterwards?

I apoligize for my ignorance, serioulsy, it has been like 15 yrs since I have done with this type of reorg.

I did seperate it out by the function you stated and ended up with some records that had 10 columns and some that had 30 columns because each row has a different amount of information.

How does the concatenate function work?