ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel should have a quick and simple "change case" function like . (https://www.excelbanter.com/excel-worksheet-functions/10452-excel-should-have-quick-simple-%22change-case%22-function-like.html)

NinaSvendsen

Excel should have a quick and simple "change case" function like .
 
I like the Change Case function in Word, especially the shortcut version,
Shift+F3, but I cannot find any similar function in Excel. I found the
"=UPPER", but it isn't really that functional.

Of course one often could copy the text from Excel to Word and back, but I
really would like the "Change Case" shortcut in Excel as well.

Peo Sjoblom

You need to roll your own


http://www.mvps.org/dmcritchie/excel/proper.htm



Regards,

Peo Sjoblom

"NinaSvendsen" wrote:

I like the Change Case function in Word, especially the shortcut version,
Shift+F3, but I cannot find any similar function in Excel. I found the
"=UPPER", but it isn't really that functional.

Of course one often could copy the text from Excel to Word and back, but I
really would like the "Change Case" shortcut in Excel as well.



All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com