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????
