Try this:

use or insert a blank column, next....say that your data is in A1 then
in the blank column type

=IF(ISNUMBER(A1),"EEL"&A1,"")
copy down as far as needed, next copy the new column and paste over the
original column ...Edit/Paste Special and Values. Clean up or delete the
new column when done.


Hope this helps!
Jean-Guy


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=510610