Maybe you need to re-state your question.

--
Don Guillett
SalesAid Software

"excelFan" wrote in message
...
hi all,
please help finding the correct length!
A1=123 7 (note: in A1 there are 4 spaces between the 3 and the 7).
now the formula RIGHT(A1,4) will yield 7
in looking for the length of this result (the 7) suing the formula
LEN(RIGHT(A1,4)) this will produce 4, where i'm assuming to be 1 ,
similarly
if A1=123 78 then RIGHT(A1,5) is 78 and the LEN(RIGHT(A1,5)) will give 5
where i'm waiting to see 2
thanks for any help