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
 
#2
It will be a custom made formula, dependent on the layout of your data.

Try the attached.

msr
 

Attachments

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"
 
#5
Updated! Sorry I didn't see this earlier. Thank you Legs for the modification!

m-s-r
 

Similar threads

Latest Threads

Top