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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Loredana12345 pe Simpatie
 | Femeie
19 ani
Galati
cauta Barbat
33 - 69 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2241
|
|
You have a sentence in cell A1, for example:
"the quick brown fox jumps over the lazy dog"
and you want to capitalize only the first letter of the cell. There isn't a direct formula for this, like there is in the case you want to capitalize the first letter of each word (using the PROPER formula).
To capitalize the first letter, write this in a new cell:
=CONCATENATE(UPPER(LEFT(A1;1));RIGHT(A1;LEN(A1)-1))
if it doesn't work, replace ; (semicolon) with , (comma).
_______________________________________
|
|
| pus acum 10 ani |
|