ExcelBanter - HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS? (https://www.excelbanter.com/excel-worksheet-functions/56628-how-do-i-convert-normal-text-into-all-caps.html)

daveylee

HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS?

I have a spread sheet with company, name and tel columns. I need to convert
the Company column to all caps. ???

Dave R.

HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS?

use =UPPER(A1) in a helper cell then copy over the originals by pasting
values.

"daveylee" wrote in message
...
I have a spread sheet with company, name and tel columns. I need to
convert
the Company column to all caps. ???

daveylee

HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS?

Thanks... your suggestion worked just fine.
daveylee

"Dave R." wrote:

use =UPPER(A1) in a helper cell then copy over the originals by pasting
values.

"daveylee" wrote in message
...
I have a spread sheet with company, name and tel columns. I need to
convert
the Company column to all caps. ???

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