first letter to upper

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
 
V

Vince Bernhardt

Assuming A1 has your data, just use the following in B1 (or wherever)
=UPPER(LEFT(A1,1))&RIGHT(A1,LEN(A1)-1)
 
R

Roger Govier

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)
 
D

Dingbat

...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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change first letter only to Upper 15
List first letter upper case 8
Upper Case and Max 3 letters 3
Force upper-case characters? 2
Setting Conditions in a Cell 4
detect upper/lower case 3
Converting from upper case to lower case 4
Display first letter of a word? 7

Top