Solved

Excel - Capitalize First Letted in each cell

Posted on 2010-08-17
4
452 Views
Last Modified: 2012-05-10
Hi,

Is there way to capitalize the first letter in each cell of Excel? (with and without the use of a formula).

Thanks.
0
Comment
Question by:tahirih
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 3

Accepted Solution

by:
Orion Newman earned 167 total points
ID: 33457534
yes the formula is called PROPER

add a column next to the column you want to capatalize and use the =proper() formula.

Not sure about doing it without a formula.
0
 
LVL 9

Assisted Solution

by:pauloaguia
pauloaguia earned 167 total points
ID: 33457647
Or, if you just want to capitalize the very first letter, instead of the first letter of every word:
=UPPER(LEFT(A1,1)) & MID(A1,2,9999999)
0
 
LVL 10

Assisted Solution

by:SANTABABY
SANTABABY earned 166 total points
ID: 33457772
I assume that you want to just capitalize the first letter for the whole cell (not each word in the cell).
Try the following:
If your orginal content is in Coulmn A, Use the following formula in the target cell (i.e. where you want to see the content with first letter capitalized):
This formula applies to the first row, however you can copy paste for other rows (i.e to convert A2, A3.... etc.)
=REPLACE(A1,1,1,UPPER(LEFT(A1,1)))
0
 

Author Closing Comment

by:tahirih
ID: 33459838
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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question