Hello everyone,

Can anybody offer a solution to my problem:

I have a list of 4 digit numbers in column A (I need to retain leading
zeros for numbers < 1000)
I have 19 cells in column B containg alpha-numeric data.
I want Column C to contain a copy of the alpha-numeric data preceded by
the 4 digit number in column A.
I'm after a Macro, I think ! or some functions to make life easier as
Column A has 440 entries !

It doesn't go down on paper as easy as it looks so I've attached an
example:

Many thanks in advance for any help one this one.

The .jpg is unreadable - I'll try something else - - -


+-------------------------------------------------------------------+
|Filename: Excel Help.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4627 |
+-------------------------------------------------------------------+

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