all caps

  1. J

    Possible to filter only ALL CAPS values from a column using vba?

    I have recently created a macro to pull specific information from a very large spreadsheet to a new page. Column A is all category codes, Column B is all Category Titles and column C is Dollar Amounts. In column B, I have Category Titles in all caps and Subcategory Titles starting with a capital...
  2. L

    Single Sheet UCase

    Any ideas on how I can force a single sheet to convert to all caps upon opening & closing a workbook? I'm currently using: Private Sub Worksheet_Change(ByVal Target As Range)Target = UCase(Target) End Sub In the active sheet but it is somewhat "laggy".
  3. F

    Need to trim various prefixed that are in ALL CAPS off of text in a column

    We have song titles in a column that have ALL CAPS prefixes that we use internally to identify the writer/origin of the song. For example: RSCAT TR Let The Sun Shine In RSC GHT Night Runner RD FGH Midnight Mountain I need to trim the ALL CAPS gibberish off of the front of the titles ...
  4. H

    ALL CAPS code help

    Hi guys. I am looking to convert all the text/characters in an excel workbook into all CAPS. The workbook has several worksheets with data in them already. I found this code below from a previous post on this board and tried to use it in the workbook module but nothing seemed to happen...
  5. B

    all caps

    In word I know how to change selected text to ALL CAPS How can I do this in Excel?
  6. S

    All CAPS Problem

    All CAPS Problem w/ Undo I searched the forum diligently and found this code (Thanks onlyadrafter and al b cnu) for making all the cells in a sheet ALL CAPS: <link rel="File-List" href="file:///C:%5CUsers%5CSam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top