<div>
Once you have calculated the properly cased values, you can replace the original values by copying the calculated values, selecting the original values, and pasting values only. Then delete the calculated values.<br />
<br />
Kevin
</div>


Once you have calculated the properly cased values, you can replace the original values by copying the calculated values, selecting the original values, and pasting values only. Then delete the calculated values.

Kevin

<div>
I got it thank you zorvek: &nbsp;<br />
you saved my life thank you
</div>


I got it thank you zorvek:  
you saved my life thank you

<div>
<div class="content wysiwyg-content">
Hi,<br />
I am using excel to list all countries. <br />
but I want to change just the first letter to be upper case. <br />
<br />
for example<br />
america<br />
france<br />
italy<br />
<br />
I want the list to be like this:<br />
America<br />
France<br />
Italy<br />
<br />
is there a way in excel to do this instead of me doing this manualy.<br />
<br />
Thanks,<br />
lulu<br />

</div>
</div>


Hi,
I am using excel to list all countries. 
but I want to change just the first letter to be upper case. 

for example
america
france
italy

I want the list to be like this:
America
France
Italy

is there a way in excel to do this instead of me doing this manualy.

Thanks,
lulu


change the first letter to upper case

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.