As always, it's useful to define your full requirements up front to save
everyone's time.

Is your data in separate columns, or all in one column?
If separate, how many columns, and what do you want in between them when
they're concatenated (a space?)?
If all in one column, what defines what you want to concatenate? Everything
after the first space and before the last space is the same?

Regards,
Fred

"EllenM" wrote in message
...
Thanks, but actually there's lots more data than that. For example:
5964 N-ACETYL-N-(2-HYDROXYETHYL)-N'-OLEOYLETHYLENEDIAMINE 101229032 177.28
5006 ACETYL TRIETHYL CITRATE 77894 175.105
5007 ACETYL TRIETHYL CITRATE 77894 175.3
5008 ACETYL TRIETHYL CITRATE 77894 175.32
5009 ACETYL TRIETHYL CITRATE 77894 178.391
5010 ACETYL TRIETHYL CITRATE 77894 181.27

You can see the final result at
http://www.accessdata.fda.gov/script...?rpt=iaListing.
The <br / causes the regnums to line up in a column.
Just looking for a simpler way to prepare this data.

Thanks for your help.