Results 1 to 9 of 9
  1. #1
    Lounger
    Join Date
    Jan 2002
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Text (Excel 2000)

    Greetings - we are running Excel 2000 and have some spreadsheets that have text in them and I am looking for a quick way to change all of the text to upper case.
    If anyone knows how to do this I would really appreciate it.
    Thank you in advance.
    Glenn

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Changing Text (Excel 2000)

    You can use a macro like the one below, but it is probably easier to select all of the cells on the sheet and paste them into Word, so that you have a table in Word. Then in Word, select Format | Change Case, UPPERCASE. Finally, copy the table from Word and paste it back into Excel. HTH --Sam<pre>Sub ConvertToUpper()
    Dim c As Range
    On Error Resume Next
    For Each c In ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants, xlTextValues)
    c.Value = UCase(c.Text)
    Next c
    End Sub</pre>

    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Lounger
    Join Date
    Jan 2002
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Text (Excel 2000)

    Thank you very much - the cut and paste in and out of Word worked perfect for us - I really appreciate your response.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Text (Excel 2000)

    Shift + F3 (probably more than once) in Word switches case between lower, title and upper.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Changing Text (Excel 2000)

    You may like to try the free add-in <A target="_blank" HREF=http://www.asap-utilities.com/>ASAP utilities</A> which allows you to do this very quickly (along with over 300 other utilities)

  6. #6
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Changing Text (Excel 2000)

    tony, this sounds fabulous! I'm going to try in.

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Changing Text (Excel 2000)

    Just a note to be sure you are aware that Excel has =LOWER(), =UPPER() and =PROPER() functions. These would require you to use a temporary column, and are probably no faster than copying to Word and pasting back from Word as Sammy suggested.
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Text (Excel 2000)

    Select the text you want to change, then run this macro:

    Sub Upper()

    For Each cel In Selection
    gg = cel.Value
    cel.Value = "=Upper(""" & gg & """)"

    Next cel

    End Sub

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Text (Excel 2000)

    Hi Micheal,

    No need to use the UPPER worksheet function, instead use the VBA UCase function:

    Cel.Value=UCase(Cel.Value)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •