RIGHT Formula not giving expected results

Good morning!
I am working on concatenating a date, the results of two RIGHT formulas and a randomly generated number. The concatenation is working perfectly but the Right formulas are not acting as expected.

There are two Right formulas, essentially identical except for the the target cells.

C12 contains the name Bob Segerorni
C17 contains the name Ronnie VanZantalous

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The first formula gives me the last 5 letters of the last name in C12
The second formula gives me the last 7 letters of the last name in C17
I had expected to get an entire last name from each formula.
I'm not sure where I went wrong, maybe I need to add a parameter somewhere but I'm not having any luck figuring out where
Any thoughts or suggestions will be very gratefully accepted
Thanks,
Bill

Thank both of you very much!!
My problem is solved and I learned something today. Maybe I should go home early...
Again, my thanks for your time and experti
Billse