Hi Cutter, thanks for the reply.

It "sort of" works but is not what I'm after.

Firstly Column A has numbers above 1000 (up to 4000) I just mentioned
1000 in the first post as I need to keep the leading zeros on all
numbers less than a thousand.

Secondly, for each cell in column A I need 19 cells in column C.

In the example; cell A1 = 0001, I need 0001 placed in cells C1 to C19
but with the info in cells B1 to B19 placed after it.
So column C would look like
C1 *0001*HS01
C2 *0001*HS02
C3 *0001*MIC
C4 *0001*SP01
down to
C19 *0001*SP16
Then C20 would start with the second cell in column A (ie *0002*)
C20 *0002*HS01
C21 *0002*HS02
etc. etc.

I've dabbled with the IF command but I cannot work out exactly what
your suggestion is doing. I does work for numbers less than 1000 but it
doesn't address the 19 entries in column B per 1 entry in column A.

'Hope that made some sort of sense !

Thanks and regards


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