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:
bella_sexy
 | Femeie
25 ani
Bucuresti
cauta Barbat
27 - 48 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
=PROPER() capitalizes the first letter of each word (like Title Case)
=UPPER() - forces all letters to be UPPER CASE
=LOWER() - forces all letters to be lower case
=UPPER(LEFT(C2;1))&MID(LOWER(C2);2;999)
where C2 is the cell where your test is in.
Source:
http://chandoo.org/wp/2010/06/07/conver ... l-formula/
_______________________________________
|
|
| |
|
