ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   change to upper/lower case (https://www.excelbanter.com/excel-discussion-misc-queries/245037-change-upper-lower-case.html)

Reza

change to upper/lower case
 
Hi all..

In MS word if we want to change word to upper/lower case, we just hit Shift
+ F3...
how about in excel...do you know the easy way to change word in cell...


thanks


reza

Jacob Skaria

change to upper/lower case
 
Since Excel is not a word prcessor; there is no shortcut you will have to use
a function..

Check out
=UPPER(a1)
=lower(A1)
=proper(A1)

If this post helps click Yes
---------------
Jacob Skaria


"reza" wrote:

Hi all..

In MS word if we want to change word to upper/lower case, we just hit Shift
+ F3...
how about in excel...do you know the easy way to change word in cell...


thanks


reza



All times are GMT +1. The time now is 03:24 AM.

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