Home |
Search |
Today's Posts |
#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!!! |
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) |