Count characters in a cell

[stuartw]

Hi Guys

Just a quick one this (famous last words).

I'm trying to count the number of characters (including spaces) in a cell - is there a formula for this?? =CELL I thought would do it but doesn't

PS What I'm actually trying to do is return the Surname in a cell containing a full name. I can get the first name easy enough with =left(A1,Find(" ",A1)-1 (I take no credit for that...) but can't get the surname - I thought I might be able to use =right but can't.

Thanks
Stu

 

[ChrisM]

Lol, true, I made that a bit too hard! Don't think I'd want to hardcode that +300 though, I think I would use VoG's Right method above.