I currently have a cell containing the following formula.
=RIGHT("000"&(T2),3)
This out puts a field like this: 00A
What I need is A00. I tried =LEFT but that didn't work.
Thanks for any help
--
denileig
-----------------------------------------------------------------------
denileigh's Profile:
http://www.excelforum.com/member.php...fo&userid=3021
View this thread:
http://www.excelforum.com/showthread.php?threadid=50955