ExcelBanter - uppercase

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - uppercase (https://www.excelbanter.com/excel-discussion-misc-queries/111997-uppercase.html)

is there a way to convert all data in a range to uppercase and also
make it so all future entries are in uppercase?

Hi,

Assume that data is in column A and column B is empty. To convert existing
data in the range A1 to A5, in B1 enter =UPPER(A1). Copy this formula down to
B5. Highlight column B, right click and select Copy. Then right click again
and select Paste Special... Values. You can then dlete column A.

To change data to upper case as you enter it, take a look at Chip Pearson's
page:
http://cpearson.com/excel/case.htm

--
Ken Hudson

" wrote:

is there a way to convert all data in a range to uppercase and also
make it so all future entries are in uppercase?

Quote:

Originally Posted by (Post 380968)

is there a way to convert all data in a range to uppercase and also
make it so all future entries are in uppercase?

refer to this link

http://cpearson.com/excel/ChangingCase.aspx

all the best