how to change small letters to capital letters

G

Guest

dear sir/madam,

how to change small letters into capital letters or capital letters into
small letters.


regards,
BALU
 
G

Guest

Hi Balu,
formula: to change from capital letters to small letters =lower()
to change from small letters to capital letters =upper()
(put the cell in the () e.g. =lower(A1)

Austuni
 
R

Roger Govier

Hi
In addition to the responses you have already received, don't forget
=PROPER(A1)
which would change "this" to "This"
 

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

how do i change the words from lower case to uppercase/capitals 3
HOW TO COUNT CAPITAL LETTERS IN DATA? 1
Changing grey column headings from numbers back to capital letters 2
display months (in date format) in capital letters 3
changing capslock letters into normal letters 4
conditional formatting - highlight Capital letters but not lower c 2
changed to capital letter 3
auto correct small leters to caps letters 4

Top