Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capitalize
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capitalize
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capitalize
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
capitalize | Excel Discussion (Misc queries) | |||
In a column, how can I capitalize ALL text? | Excel Discussion (Misc queries) | |||
How do I Capitalize all the font on a worksheet? | Excel Discussion (Misc queries) | |||
Number Format - Capitalize | Excel Discussion (Misc queries) | |||
Capitalize text | Excel Discussion (Misc queries) |