How do I capitalize and parse in the same formula?

[blondegreenjeans]

I need to write a formula that does 2 functions, LEFTand UPPER. Is this
possible?
I need to "grab" the first three leeters of a word and capitalize them to
add to numbers to create a part number.

Thanks in advance....

[Peo Sjoblom]

=UPPER(LEFT(A1,3))

--
Regards,

Peo Sjoblom

(No private emails please)


"blondegreenjeans" <blondegreenjeans@discussions.microsoft.com> wrote in
message news:B1FCFF0C-D363-4240-816F-5CED04DAF669@microsoft.com...
>I need to write a formula that does 2 functions, LEFTand UPPER. Is this
> possible?
> I need to "grab" the first three leeters of a word and capitalize them to
> add to numbers to create a part number.
>
> Thanks in advance....

[Dave Peterson]

=upper(left(a1,3))&"1234"
or maybe:
=upper(left(a1,3))&text(b1,"0000")

if b1 contains a number.

blondegreenjeans wrote:
>
> I need to write a formula that does 2 functions, LEFTand UPPER. Is this
> possible?
> I need to "grab" the first three leeters of a word and capitalize them to
> add to numbers to create a part number.
>
> Thanks in advance....

--

Dave Peterson