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