CAPITALIZED ALL WORDS FROM WROKSHEET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

dear sir,
i want to know that how can we change the all worksheet which is in small
letter convert to capital letter?
 
Although all caps isn't recommended for reading and screen size, you can use
the "upper" command. I usually have to do the opposite, with the "Lower", or
sometimes the "proper" that capitalizes the first leter only.

to convert text in a1, in a blank cell type "=upper(a1)" you can then drag
the formula down or across. when you are finished, copy and paste values
over the original.
 
The free Excel add-in "Excel Extras" will do that and more.
Download from...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"convert all capital letter from excel"
wrote in message
dear sir,
i want to know that how can we change the all worksheet which is in small
letter convert to capital letter?
 

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 to change small letters to capital letters 4
how do i change the words from lower case to uppercase/capitals 3
uppar case 5
Sentence with first letter in Capital, rest all in small. 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
changed to capital letter 3

Back
Top