ExcelBanter - Capitalize

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

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

- - Capitalize (https://www.excelbanter.com/excel-discussion-misc-queries/167899-capitalize.html)

if I have a column with data in lower case like Rtp Tlp and I should have
them in CAPs can I change it for teh whole column

On Nov 29, 6:06 pm, officegirl
wrote:
if I have a column with data in lower case like Rtp Tlp and I should have
them in CAPs can I change it for teh whole column

the upper() command is what you're looking for.

To elaborate on BartParry's response:
In another column, set up a formula like:
=UPPER(A1)
example assumes your text to convert is in A1, and the formula is also in a
column on row 1. Fill the formula down as far as you need to get all of the
mixed text entries.

Then select all of the cells with the UPPER() formula in them and use Edit |
Copy, then go click in the first cell in the original column with text to
change and use Edit | Paste Special with the "Values" option chosen. You can
then go back and delete that extra column you used with the UPPER() formulas
in it.

"officegirl" wrote:

if I have a column with data in lower case like Rtp Tlp and I should have
them in CAPs can I change it for teh whole column