Hi,

I have a column of data that consists of 2 and 3 digit numbers (eg 215
or 56), I need to add a prefix of EEL to all of them. As there are over
400 of them, they are all different and they are not concurrent (some
numbers are missing) I cant just drag and fill.....

Any ideas?


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=510610