• ARRSE have partnered with Armadillo Merino to bring you an ARRSE exclusive, generous discount offer on their full price range.
    To keep you warm with the best of Merino gear, visit www.armadillomerino.co.uk and use the code: NEWARRSE40 at the checkout to get 40% off!
    This superb deal has been generously offered to us by Armadillo Merino and is valid until midnight on the the 28th of February.

help please

#1
I am desparately trying to fill in a nominal role with very little time to do it, and know that there is a formula for ZAP numbers in excel but cant for the life of me remember it Can anyone out there help me
 

Legs

ADC
Book Reviewer
#4
If you make a slight change to the formula it will automatically make the 2 letters of the surname uppercase:

=LEFT(B2,2) & RIGHT(A2,4)

becomes:

=UPPER(LEFT(B2,2)) & RIGHT(A2,4)

so"sm3456" becomes "SM3456"
 

Latest Threads

New Posts