I have a data sheet with a mix of upper and lower case text in various fonts.
How do I change it to all upper case? Can change font & size ok. Thanks.
Regards John
I have a data sheet with a mix of upper and lower case text in various fonts.
How do I change it to all upper case? Can change font & size ok. Thanks.
Regards John
John, you can use a macro like this, select the range you want to change and
then run it
Sub MAKE_CAPS()
'select range and run this to change to all CAPS
Dim cel As Range
For Each cel In Intersect(Selection, _
ActiveSheet.UsedRange)
cel.Formula = UCase$(cel.Formula)
Next
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"John" <[email protected]> wrote in message
news:[email protected]...
> I have a data sheet with a mix of upper and lower case text in various
fonts.
> How do I change it to all upper case? Can change font & size ok. Thanks.
> Regards John
John,
You will have to use the "Upper" worksheet function in a blank column.
If you have multiple columns of data, that is not always a useful fix.
The free Excel add-in "Excel Extras" adds... Lower, Upper, Proper and Sentence
case options to the format menu (select your data and click the menu item).
The add-in also does other useful stuff.
Download from (no registration required) ...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA
"John"
<[email protected]>
wrote in message
I have a data sheet with a mix of upper and lower case text in various fonts.
How do I change it to all upper case? Can change font & size ok. Thanks.
Regards John
John
Example only..........
Assume you have data in column A
In B1 enter =UPPER(A1)
Copy down column A
When happy, copy Column B then, in place, Edit>Paste Special>Values>OK>Esc.
Gord Dibben MS Excel MVP
On Sun, 30 Jul 2006 08:07:01 -0700, John <[email protected]> wrote:
>I have a data sheet with a mix of upper and lower case text in various fonts.
>How do I change it to all upper case? Can change font & size ok. Thanks.
>Regards John
Thanks for your advice - works well! Regards John
"Jim Cone" wrote:
> John,
> You will have to use the "Upper" worksheet function in a blank column.
> If you have multiple columns of data, that is not always a useful fix.
>
> The free Excel add-in "Excel Extras" adds... Lower, Upper, Proper and Sentence
> case options to the format menu (select your data and click the menu item).
> The add-in also does other useful stuff.
>
> Download from (no registration required) ...
> http://www.realezsites.com/bus/primitivesoftware
> --
> Jim Cone
> San Francisco, USA
>
>
> "John"
> <[email protected]>
> wrote in message
> I have a data sheet with a mix of upper and lower case text in various fonts.
> How do I change it to all upper case? Can change font & size ok. Thanks.
> Regards John
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks