count Re-occurrences

Originally Posted by stevekirk

hi, bryan

hope you had a good break

the 2l, 2l/2s in column e MUST ALWAYS be the last 5 charecters in the cell
this is because the field in the main frame has only 23 spaces

therefore ak has right(e2,5) this then unfortuatly leave spaces in front of the ones that say 2L OR 2S then your other formulars dont work unless i remove the spaces manaullly

can we put in another formular to overcome this

thanks

steve

One of two options, you can use Trim(A1) on any cell that has leading or trailing spaces to get the valid data, or, if you are trying to access 5 characters from A1 and it is only 1 character long use A1&" " etc
=Right(" "&A1,5)
or
=Left(A1&" ",5)
etc.

so right("_____"&E2,5)
should work for you. (with 5 spaces)

hth
---