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