Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
oana89 Profile
 | Femeie
25 ani
Bucuresti
cauta Barbat
25 - 46 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
Source:
http://www.mrexcel.com/forum/excel-ques ... -cell.html
---
=LEN(A1)
counts the characters in cell A1
---
if there are blanks / spaces that you don't want to count:
=LEN(A1)-(LEN(A1)-LEN(SUBSTITUTE(A1," ","")))
or
=LEN(SUBSTITUTE(A1," ",""))
_______________________________________
|
|
| |
|
