hi
from what you describe, i would suggest text to columns
2003 menubardatatext to columndelimited, commafinish
2007 data tabtool grouptext to columnsdelimited, commafinish

make a back up prior to runing the text to column wizard.

regards
FSt1

"Danielsjt" wrote:

I have a spreadsheet and in column D contains Equipment #'s and their
description separated by a comma. How can I separate the Equipment #'s into
Column G.
Sheet contains approx. 1500 rows.

Example:
T-8900-F, Fresh Water storage Tank