PC Review


Reply
Thread Tools Rate Thread

How do i make text in one column all capital letters

 
 
=?Utf-8?B?dHJhaW5zcG90dGVyMjA=?=
Guest
Posts: n/a
 
      28th Sep 2004
i have one column of data i want to change the text into capital letters
without doing each item individually

 
Reply With Quote
 
 
 
 
Bernie Deitrick
Guest
Posts: n/a
 
      28th Sep 2004
TrainSpotter,

=UPPER(A1)

will convert the text in A1 to all caps. You can then copy the formula down
to match your data. Then you can copy / paste special values, and get rid
of your original text.

HTH,
Bernie
MS Excel MVP

"trainspotter20" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> i have one column of data i want to change the text into capital letters
> without doing each item individually
>



 
Reply With Quote
 
 
 
 
JulieD
Guest
Posts: n/a
 
      28th Sep 2004
Hi

either use code

Sub changecase()
For Each cell In Range("B1:B100")
cell.Value = UCase(cell.Value)
Next
End Sub

change "B1:B100" for the actual range of cells that you want to do this to
- to use this code, right mouse click on the sheet tab with the data in it
and choose view / code
- you should see the name of your workbook on the left in bold, click on it
(if you can't see it, choose view / project explorer from the menu)
- choose insert / module
- on the right hand side where the white piece of paper has appeared, copy &
paste the code above (from Sub to End Sub)
make sure your cursor is somewhere in the code and press the F5 key to run
the code
- close the code window using the X in the top right
- before using code like this, please take a backup of your workbook.

or
insert a column to the right of the column you want to change
in the first cell type
=UPPER(A1)
where A1 is the first cell of the column to change
fill down (double click on little + on bottom right of the cell with the
formula in it)
then select this column, choose edit / copy
click on the column header of the lower case version of the data and choose
edit / paste special - values to replace the old data and then delete this
column

Hope this helps
Cheers
JulieD


"trainspotter20" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>i have one column of data i want to change the text into capital letters
> without doing each item individually
>



 
Reply With Quote
 
David McRitchie
Guest
Posts: n/a
 
      28th Sep 2004
Assuming it is something you typed in so that you are looking at
constants and not formulas.

To fix existing entries use a macro see Upper_Case macro at
http://www.mvps.org/dmcritchie/excel/proper.htm#upper

To correct entries just after entering them use a Change Event Macro
like the one found just below the above subroutine.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"trainspotter20" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> i have one column of data i want to change the text into capital letters
> without doing each item individually
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change from capital letters to small letters and vice versa Tobias Microsoft Word Document Management 1 3rd Dec 2007 01:39 PM
how to change small letters to capital letters =?Utf-8?B?SE9XIFRPIENIQU5HRQ==?= Microsoft Excel Misc 4 30th May 2007 01:12 AM
how do i turn all letters into capital letters? =?Utf-8?B?S2VpdGhU?= Microsoft Excel Misc 3 11th May 2007 02:13 PM
How to change small letters into capital letters? =?Utf-8?B?QmxpbmRh?= Microsoft Access 4 15th May 2006 06:49 PM
Word Macro: How to convert capital letters to lower case letters Leonardo Da Vinci Microsoft Word Document Management 4 8th Jun 2004 02:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:35 AM.