Inserting text before right command

[Turnipboy]

I am using the command:

=RIGHT($C2,1)

This gives me a number output. How do I insert a word before it, i.e.
instead of giving me say "3" it gives me "Position 3"?

Thanks

 

[Barb Reinhardt]

="Position "&RIGHT($C2,1)

 

[Bob Phillips]

Or use a custom format of

"Position "0

--

HTH

RP
(remove nothere from the email address if mailing direct)