There may really be 30 characters
If this is data which has come in from an outside sourse there may be spaces
try
=len(trim(A2))
You may have to modify how the cells are referenced or handeled if this is a
significant issue.



"Tink" wrote:

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!!!