proper change case text

  1. M

    macro - select unknown data range and convert to proper case

    Hi, I have a different excel spreadsheets which I must convert to PROPER case My difficulty is that have two macros that seem work individually and I am wondering how I can combine both and if this is possible. Firstly I am using the following to select the 'range' of values Sub...
  2. U

    Can I force a cell to Proper Case if is already using Conditional Formating and Data Validation?

    My client wants, "Yes" or "No" in proper case so if someone enters one of them in upper or lower case the Data Validation gives them an error. Can this be changed to proper case before Data Validation kicks in? I would rather not do this in a macro if there is another way. Thank you,
  3. F

    Proper function: how to use

    I have a column of text; some cells have all upper case letters. I want all cells to have First letter only upper case, the rest in lower case. I tried the PROPER function but am doing it wrong. I highlight the entire column, select PROPER, put the cells locations in the blank field (e.g...

Watch MrExcel Video

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