ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i change an existing cell or cells to upper case? (https://www.excelbanter.com/excel-discussion-misc-queries/259462-how-do-i-change-existing-cell-cells-upper-case.html)

dopy

how do i change an existing cell or cells to upper case?
 
how do i change an existing cell or cells to upper case?

Fred Smith[_4_]

how do i change an existing cell or cells to upper case?
 
In an adjacent column, use the Upper function, as in:
=upper(a1)

You can then convert this to values, and delete the original.

Regards,
Fred

"dopy" wrote in message
...
how do i change an existing cell or cells to upper case?




All times are GMT +1. The time now is 02:52 PM.

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