first letter to upper

  • Thread starter Thread starter Dingbat
  • Start date Start date
D

Dingbat

Hello
Please can you tell me how to change only the first letter of the first word
in a cell, to upper case but not the other words.
(Excel 03)
Ta
D
 
Assuming A1 has your data, just use the following in B1 (or wherever)
=UPPER(LEFT(A1,1))&RIGHT(A1,LEN(A1)-1)
 
Hi

With your data in A1 enter in B1
=PROPER(A1)
Copy down as required.

Then, copy column B>Paste Special>Values only to "fix" the formulae to
values.
Column A can then be deleted (if required)
 
...only the first letter of the first word in a cell, to upper case but
Your formula changes all the words' first letter into upper case.
Thanks for your time anyway
 
Back
Top