I need a formula to set the first letter of each word in upper-case.
Try this formula:
Basically, we extract the first letter on the left (LEFT())
which is then passed in uppercase (UPPER())
, then extract the right side (RIGHT())
after the first letter (LEN(D2))- 1)
, concatenates all ...
Thanks to Rinos
for this tip.
Published by aakai1056
Latest update on April 12, 2012 at 08:49 AM by aakai1056.