Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

change the first letter to upper case

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
0
lulu50
Asked:
lulu50
  • 2
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
Use a formula in an unused column:

=PROPER(A1)

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
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
0
 
lulu50Author Commented:
I got it thank you zorvek:  
you saved my life thank you
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now