Inserting text before right command

T

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
 
B

Bob Phillips

Or use a custom format of

"Position "0

--

HTH

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