Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change Text Case
In March of 2004, someone asked how to make all text characters in cells
uppercase. While personally this is something I would not want to do, someone in my office has posed the question. I searched for a similar query and found that in March of 2004, someone asked the same question. McRitchie of MVP responded by saying, "You can use the UPPER Worksheet Function =UPPER(A1) followed by use of the fill handle, but then you have the original value and the new value in two separate cells, and have to go through some extra bother to copy the new column, Edit, paste special, values, before you can remove the original column." What? If I have text in A1 to A6, I put =Upper(A1) where and fill what? Thanks!! |
#2
|
|||
|
|||
Put the formula in an empty column, say column B:
B1: =Upper(A1) Copy the formula down to B6. Select B1:B6. Copy the range. Select A1:A6. Choose Edit/Paste Special, and select the Values radio button. Click OK. In article outsoftware.com, "Lilbit" wrote: In March of 2004, someone asked how to make all text characters in cells uppercase. While personally this is something I would not want to do, someone in my office has posed the question. I searched for a similar query and found that in March of 2004, someone asked the same question. McRitchie of MVP responded by saying, "You can use the UPPER Worksheet Function =UPPER(A1) followed by use of the fill handle, but then you have the original value and the new value in two separate cells, and have to go through some extra bother to copy the new column, Edit, paste special, values, before you can remove the original column." What? If I have text in A1 to A6, I put =Upper(A1) where and fill what? Thanks!! |
#3
|
|||
|
|||
Thank you very much!! It worked like a charm!!!
|
#4
|
|||
|
|||
Hi Lilbit,
and as you kind quoted part of one of my responses, you now have the value in two columns. If you simply want to change the original column or other selection of cells in place you would use a macro as in http://www.mvps.org/dmcritchie/excel/proper.htm#upper You select, run macro, and you would be done ... as opposed to a little dance after using a formula =UPPER(A1), comprised of Copy column B by selecting it then using Ctrl+C to copy (optional to select column A if you want the original column changed instead of B) Edit, Paste special, values Now you can eliminate whichever column is extraneous The optional switch in selection to Column A would be if other cells refer to column A the would no longer reference a cell if you eliminated that column. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Lilbit" wrote in message lkaboutsoftware.com... Thank you very much!! It worked like a charm!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
change typed text to upper case | Excel Discussion (Misc queries) | |||
How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) |