ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting commands (https://www.excelbanter.com/excel-discussion-misc-queries/230840-formatting-commands.html)

Jahsoulster

Formatting commands
 
Why doesn't Excel have the formatting command 'change case'. This I've always
wondered about. It has many if not all the other ones that Word has, so why
not include the 'change case' command?

Jacob Skaria

Formatting commands
 
Hope you know about the function =UPPER()

A1 = "this is fun"
=UPPER(A1)

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


"Jahsoulster" wrote:

Why doesn't Excel have the formatting command 'change case'. This I've always
wondered about. It has many if not all the other ones that Word has, so why
not include the 'change case' command?


Sheeloo

Formatting commands
 
In my view it is because it is a number crunching application and not a word
processing application. It provides cell/row/column based processing (not
word/sentence/paragraph).

It does have UPPER function to convert any cell value to uppercase.

"Jahsoulster" wrote:

Why doesn't Excel have the formatting command 'change case'. This I've always
wondered about. It has many if not all the other ones that Word has, so why
not include the 'change case' command?



All times are GMT +1. The time now is 11:48 AM.

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