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.