View original (French)

Excel - count the number of characters without spaces

beemouse -  
 dd -
Hello -
I would like to count the number of characters (in text) in an Excel cell without spaces. Is there a simple formula for that?

I found this: =LEN(D3)
but it also counts the spaces.....

Thank you for any help in advance!!

Configuration: Windows XP / Firefox 3.6.3

1 answer

  1.
    pijaku Posted messages 13513 Registration date   Status Moderator Last intervention   2 773
     
    Hello,
    In addition to NBCAR, you need to use the SUBSTITUTE function. The latter will replace spaces with nothing:
    =NBCAR(SUBSTITUTE(D3," ",""))
    --
    Best regards,
    -- Every problem has its solution. If there is no solution, where is the problem? --
    11
    1. dd
       
      You're welcome!
      0