help please

Discussion in 'Army Pay, Claims & JPA' started by alb395, Mar 30, 2009.

Welcome to the Army Rumour Service, ARRSE

The UK's largest and busiest UNofficial military website.

The heart of the site is the forum area, including:

  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. msr

    msr LE

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

    Try the attached.

    msr
     

    Attached Files:

  3. 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
     
  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. msr

    msr LE

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

    m-s-r
     
  6. You are very welcome.