Thank you for your time Sandy, we're very nearly there !

The macro is hard for me to understand, as I said before I'm fairly new
to all this, so I don't know which "bit" needs tweaking.

Once the macro is run the resulting column (column C) is "parsed" with
the 19 cells in column B which is perfect, but the prefix is always
cell A1.

ie. as in my previous posts, column C has 0001 as the 1st 4 digits in
every cell (all 9000 of 'em) so the macro isn't stepping down column
A.

Sorry to be pain but if this works it will save me an enormous amount
of time in the future.

Many thanks


--
pc300d
------------------------------------------------------------------------
pc300d's Profile: http://www.excelforum.com/member.php...o&userid=33474
View this thread: http://www.excelforum.com/showthread...hreadid=532785