Quick change lower case to upper case in excel

  Roseandaleman 12:00 19 Jan 08
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 08

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 08

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 08

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 08

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 08

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 09

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…