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


  • To ignore the other dashes, use


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


    Tuesday, December 9, 2014 4:39 PM

All replies