Hmmm..that is the trick. Sometimes it might contain A or B and others
it might be BL or 1.
Whatever it returns I need the characters on the left with the
appropriate blank spaces at the end so that it makes 3 spaces and/or
characters total.
--
denileigh
------------------------------------------------------------------------
denileigh's Profile:
http://www.excelforum.com/member.php...o&userid=30211
View this thread:
http://www.excelforum.com/showthread...hreadid=509552