View Single Post
  #1   Report Post  
beefycj5
 
Posts: n/a
Default Counting the number of letters in a cell


Can Excel count the numbers of letters in a cell that has mixed letters
and numbers? Can you restrict =LEN to only letters (or only numbers)?

IE - ABC123
# of letters = 3

Thanks,
Adam


--
beefycj5
------------------------------------------------------------------------
beefycj5's Profile: http://www.excelforum.com/member.php...o&userid=16353
View this thread: http://www.excelforum.com/showthread...hreadid=375769