How to change string case in Excel 2013

Question

I want to change case of a string in Excel. I am using MS 2013 suite.

I have checked various answers where people have suggested to use third party add-on or to user UPPER() or LOWER() function.

But it is tedious to use a function and I am not in a position to add a add-on to machine.

Can anyone please suggest any hot key(short cut key) to complete this requirement of mine.

Answer 1

Select a string (highlight). Go to menu and start recording a macro.

Do necessary action (ok that is nebulous).

Stop recording macro. Assign hotkey. Save macro.

Now next time, highlight something. Hit hotkey.

Note that later you can go in and modify the macro VBA code that you find for a particular solution

Answer 2

thanks @Drew Pierce for seeding the idea of macro.

I have created the below macro:

Sub Change_Case()
'
' Macro change case
' Keyboard Shortcut: Ctrl+Shift+L

Dim Range1 As Range, cell As Range
Set Range1 = Selection
For Each cell In Range1
cell.Value = LCase(cell.Value)

Next cell
End Sub

And now with a short cut key(Ctrl+Shift+L) i am able to do my work.

Thanks again.