Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change existing column to capital letters
current column is mixed upper and lower case names. I want the entire column
to be capital letters. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change existing column to capital letters
Hi Fred
Assuming data is in column A, then in an empty column enter =UPPER(A1) Copy down new column for the extent of data in column A. Copy new column and Paste SpecialValues back over column A. Delete new column. -- Regards Roger Govier "fredg" wrote in message ... current column is mixed upper and lower case names. I want the entire column to be capital letters. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change existing column to capital letters
Roger: Thank you for your assistance. I tried your suggestion, but all it
did was copy the 1st name down the entire column. Did I do something wrong? I tried your suggestion numerous times to eliminate any errors on my part, but i kept getting the same results. Pls. reply. thanks in advance!! fredg "Roger Govier" wrote: Hi Fred Assuming data is in column A, then in an empty column enter =UPPER(A1) Copy down new column for the extent of data in column A. Copy new column and Paste SpecialValues back over column A. Delete new column. -- Regards Roger Govier "fredg" wrote in message ... current column is mixed upper and lower case names. I want the entire column to be capital letters. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change existing column to capital letters
Hi
It sounds as though ToolsOptionsCalculation is set to Manual. Select Automatic instead and it should work fine. -- Regards Roger Govier "fredg" wrote in message ... Roger: Thank you for your assistance. I tried your suggestion, but all it did was copy the 1st name down the entire column. Did I do something wrong? I tried your suggestion numerous times to eliminate any errors on my part, but i kept getting the same results. Pls. reply. thanks in advance!! fredg "Roger Govier" wrote: Hi Fred Assuming data is in column A, then in an empty column enter =UPPER(A1) Copy down new column for the extent of data in column A. Copy new column and Paste SpecialValues back over column A. Delete new column. -- Regards Roger Govier "fredg" wrote in message ... current column is mixed upper and lower case names. I want the entire column to be capital letters. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nedd to change column headings from numbers back to letters | New Users to Excel | |||
macro | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
change column name from letters to numbers? | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) |