This didn't work. It just replaced the whole row with the header from it's column.

It works for me.

Do note that, as with most Excel formulas posted in forums where no cell address context is given, the formula assumes the data are in A1 and the formula is in any other cell. Obviously, you can't put a formula in the very cell you want to extract data from and, if the cell you want to process isn't A1, you need to change the formula's cell references.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]