One mo

=if(a1="","","EEL-"&text(a1,"000"))

So leading 0's will show up:
EEL-001

Alec H wrote:

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

--

Dave Peterson