Hi,

My problem is this. I have a specific row of data that I need to
copy part of down a column, until the next row of data.

The data is in a format 12345 abcd efgh ijkl

I only need to copy the numeric portion (12345) down the column, until
the next row I need to copy (same format) shows up. What's the
best/quickest way to do this. It's like an =IF function, but I'm not
sure of the syntax.

Thanks