MS EXCEL Gurus Step Inside

[qxm]

OK, this might not take an excel guru........this is what I'm trying to do:

I have a list of items listed in columns, each cell of that column has data formatted like this:

COLUMN:

data1, data2, data3
data4, data5, data6

I need a macro or something similar which would allow me to erase everything found after a comma and only keep the first set of data ....so the output should be:

COLUMN:

data1
data4

Any ideas anyone????

[GrouchyAdmin]

Just import as a CSV, click A1 at the top, ctrl-c, go to page 2, paste?

If you want to use something like TextPad, you could just 'replace, regex, ',.*$', nothing, replace all.

Or, you could just abuse unix if it's not xls format. Don't need nothin fancy.
cut -d, -f1 < file

However, I won't pretend to have tried to make an excel macro in years.

[qxm]

ahhh the 'replace, regex, ',.*$' thing worked like a charm.............

I was thinking I would have to create a macro .... haven't done one in years either.....but this worked just fine........thanks m8!!!!!

[GrouchyAdmin]

No worries. I <3 regex.

[CunningStunt]

Data >> text to columns ;-)