Hi,

I'm trying to count the number of characters in a cell. At the moment i've
tried using =LEN(A2). This works fine when all characters are numeric, but
when there are letters in the mix, it shows the total number as 30 regardless
of whether there are 8, 12 or 14 characters in the code.

Someone please help!!!