Quick change lower case to upper case in excel

  Roseandaleman 12:00 19 Jan 2008
Locked

Hello all
Can anyone out there give me an easy way to change a word or a line in Lower Case to Upper Case in Excel and Word
Thanks
Skylooker

  VoG II 12:08 19 Jan 2008

In Word, highlight a selection and press Shift + F3 to toggle between lower, Proper and UPPER case.

in Excel you can use e.g. =UPPER(A1)

  VoG II 12:22 19 Jan 2008

In Excel, to change the case 'in place' press ALT + F11 to open the Visual Basic Editor, Insert > Module. Copy and paste in

Sub ToCaps()
Dim r As Range
For Each r In Selection
r.Value = UCase(r.Value)
Next r
End Sub

then close the VBE. Select the cells to change then Tools > Macro > Macros, highlight ToCaps and click the Run button. You could also assign this macro to a button from the Forms toolbar or to a keyboard shortcut.

  Roseandaleman 13:06 19 Jan 2008

Thanks for your assistance with Lower case to Upper case, works great in word but unable to sort it in Excel, cant' seen to handle the VBE, any other easy way, or further explanations of VBE
Thanks
Skylooker

  VoG II 13:15 19 Jan 2008

If you press ALT + F11 the VBE should open. On the Insert menu select Module and a white area should appear on the right hand side of the screen. Copy the code above and paste it into the white area. The result should look something like this: click here

Then close the VBE using the X, select the range of cells that you want to convert and Tools > Macro > Macros, highlight ToCaps and click the Run button.

  exdragon 20:19 19 Jan 2008

That works a treat, but have you looked at a programme called ASAP utilities? click here There are loads of things you can do, just in case VoG™ ever goes on holiday and you can't wait for his return!!

  scoochie 15:22 28 May 2009

copy the part of the spreadsheet that you want to toggle case on; paste in word; select the text to have toggled; shift+F3 until you have the desired result; copy from word and paste over original cells in excel.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?