Formatting Question

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.

What might T2 contain? Is it just a single letter? What do you want to return if T2 is blank?

Possibly

=T2&"00"

if T2 contains only one letter

=Left(T2&"000",3)

would be the equivalent that produces what you show.

If T2 is blank it would display 000

--
Regards,
Tom Ogilvy


"denileigh" <denileigh.22vph0_1139348701.8224@excelforum-nospam.com> wrote
in message news:denileigh.22vph0_1139348701.8224@excelforum-nospam.com...
>
> 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.
>
>
> --
> denileigh
> ------------------------------------------------------------------------
> denileigh's Profile:
http://www.excelforum.com/member.php...o&userid=30211
> View this thread: http://www.excelforum.com/showthread...hreadid=509552
>

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.