none
Help with a vlookup situation RRS feed

  • Question

  • I have @ A1 the following data V12878/A-01-94, @ A2 W95258/AB-25-965, and @ A3 W98525/A-04-2. I want to create a formula to check the number of characters after the first – cannot use the / since sometimes after the symbol I have one character but sometimes I have two characters.


    Fernando Salgueiro

    Tuesday, December 9, 2014 4:17 PM

Answers

  • To ignore the other dashes, use

    =LEN(SUBSTITUTE(MID(A1,FIND("-",A1)+1,LEN(A1)),"-",""))

    To not ignore other dashes (if they count as characters)

    =LEN(MID(A1,FIND("-",A1)+1,LEN(A1)))


    Tuesday, December 9, 2014 4:39 PM

All replies