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