Capitalize text

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

Guest

I have a worksheet that all text is in lower case, and would like it in
upper case. Can I select all text ,then select a coomand to change the text
to upper case?

Thanks in advance

Eddie
 
Say all your information is in columns A1 through F10. I go to column G1,
enter the formula =UPPER(A1) then I copy and paste (easiest to drag) that
formula all the way down to L10. Then highlight all your new upper case data
in cells G1 thru L10, hit copy, then paste special - formulas as values.
Then you can delete colums A through F. Anyway, that's how I do it.
 
You must log in or register to reply here.

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

Restrictions in format 1
Print Area to include text box 10
Formatting cells to only upper case 5
How do you change the Capitalization in an Excel Workbook? 7
convert lower to upper case automatically without using UPPER 6
CHANGE LOWER CASE TO UPPER CASE? 1
Capital Text 8
Excel: how to convert text to upper case upon entry? 13

Back
Top