Menu
I have a column of text that is camelcase and needs to be lower camelcase:
+---------------+---------------+
| Original | Desired |
+---------------+---------------+
| OrderStatus | orderStatus |
+---------------+---------------+
| ActiveFlag | activeFlag |
+---------------+---------------+
| CancelledFlag | cancelledFlag |
+---------------+---------------+
271
To use a keyboard shortcut to change between lowercase, UPPERCASE, and Capitalize Each Word, select the text and press SHIFT + F3 until the case you want is applied.
You can use the Ctrl + Shift + F shortcut to convert text to lower case. This shortcut will convert all letters in the selected cells to lowercase letters. For example, if you have the text "HOW TO USE THE EXCEL UPPERCASE SHORTCUT" in a cell, this shortcut will convert it to "how to use the excel uppercase shortcut".
Type =PROPER(A2), and press Enter. Tip: Use the formula =UPPER(A1) for all UPPERCASE; =LOWER(A1) for all lowercase.
This will do the trick:
=REPLACE(A2,1,1,LOWER(LEFT(A2)))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
