help please

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
 

msr

LE
It will be a custom made formula, dependent on the layout of your data.

Try the attached.

msr
 

Attachments

  • zap_number.zip
    3.5 KB · Views: 639
THANK YOU SO MUCH, A BIT OF PLAYING AROUND AND MY NOMINAL ROLE NOW COMPLETES THE ZAP NUMBERS FOR ME.

HOURS OF MESSING ABOUT SAVED
 

Legs

ADC
Book Reviewer
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"
 

msr

LE
Updated! Sorry I didn't see this earlier. Thank you Legs for the modification!

m-s-r
 

Legs

ADC
Book Reviewer
You are very welcome.
 

New Posts

Latest Threads

Top