Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I force all capital in a column of lower case names?
I read the help, but it doesn't tell me where to enter the formula.
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I force all capital in a column of lower case names?
If you do not have a blank column next to the mentioned column, then insert
one. Enter the formula in a cell adjacent to the cell you want to change, and copy down. Then copy this column, go to the original column, select a cel, right click and click on Paste Special, tick values. Delete the helper column. Iow, with you lower case data in Column E, click on Column F, if not empty, and insert a column. F is then an empty column. Say your data starts in E2, then in F2 enter =UPPER(E2). Move cursor to the bottom right hand corner of the cell. When it changes, double click. -- Hth Kassie Kasselman "Dean-Xceldata" wrote: I read the help, but it doesn't tell me where to enter the formula. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I force all capital in a column of lower case names?
Enter the formula in a helper column.
Assuming column A is your data in lower case. In B1 enter =UPPER(A1) Double-click on the fill handle of B1 to copy down. When happy, select column B and EditPaste Special(in place)ValuesOKEsc. Delete original column A Gord Dibben MS Excel MVP On Wed, 14 Feb 2007 11:56:20 -0800, Dean-Xceldata wrote: I read the help, but it doesn't tell me where to enter the formula. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I force all capital in a column of lower case names?
I just learned about this the other day. (I told you I was an Excel novice.)
That will save me a lot of time at work! -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Enter the formula in a helper column. Assuming column A is your data in lower case. In B1 enter =UPPER(A1) Double-click on the fill handle of B1 to copy down. When happy, select column B and EditPaste Special(in place)ValuesOKEsc. Delete original column A Gord Dibben MS Excel MVP On Wed, 14 Feb 2007 11:56:20 -0800, Dean-Xceldata wrote: I read the help, but it doesn't tell me where to enter the formula. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I force all capital in a column of lower case names?
Joanne
What saves even more work is to use VBA to convert all cells in a selection at once. No formulas hence no special pasting after. Chip Pearson has an add-in at his site for doing this. http://www.cpearson.com/excel/download.htm Gord On Wed, 14 Feb 2007 15:48:59 -0500, "JoAnn Paules [MVP]" wrote: I just learned about this the other day. (I told you I was an Excel novice.) That will save me a lot of time at work! |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I force all capital in a column of lower case names?
I have to be careful about using VBA. One - I'm clueless about VBA. Two - my
coworkers know less than I do and it just complicates their life. I really want them to decide that they want to hire me direct after my contract with them expires so I try to keep things simple if they are going to be using my files. -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Joanne What saves even more work is to use VBA to convert all cells in a selection at once. No formulas hence no special pasting after. Chip Pearson has an add-in at his site for doing this. http://www.cpearson.com/excel/download.htm Gord On Wed, 14 Feb 2007 15:48:59 -0500, "JoAnn Paules [MVP]" wrote: I just learned about this the other day. (I told you I was an Excel novice.) That will save me a lot of time at work! |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I force all capital in a column of lower case names?
create a lot of complicated macros that they don't understand, then they are
bound to re-hire you, so they can continue working <bg -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JoAnn Paules [MVP]" wrote in message ... I have to be careful about using VBA. One - I'm clueless about VBA. Two - my coworkers know less than I do and it just complicates their life. I really want them to decide that they want to hire me direct after my contract with them expires so I try to keep things simple if they are going to be using my files. -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Joanne What saves even more work is to use VBA to convert all cells in a selection at once. No formulas hence no special pasting after. Chip Pearson has an add-in at his site for doing this. http://www.cpearson.com/excel/download.htm Gord On Wed, 14 Feb 2007 15:48:59 -0500, "JoAnn Paules [MVP]" wrote: I just learned about this the other day. (I told you I was an Excel novice.) That will save me a lot of time at work! |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I force all capital in a column of lower case names?
Murphy's Law tends to hit me a lot. That would probably come back to bite me
on my ............ um, workbook. -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Bob Phillips" wrote in message ... create a lot of complicated macros that they don't understand, then they are bound to re-hire you, so they can continue working <bg -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JoAnn Paules [MVP]" wrote in message ... I have to be careful about using VBA. One - I'm clueless about VBA. Two - my coworkers know less than I do and it just complicates their life. I really want them to decide that they want to hire me direct after my contract with them expires so I try to keep things simple if they are going to be using my files. -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Joanne What saves even more work is to use VBA to convert all cells in a selection at once. No formulas hence no special pasting after. Chip Pearson has an add-in at his site for doing this. http://www.cpearson.com/excel/download.htm Gord On Wed, 14 Feb 2007 15:48:59 -0500, "JoAnn Paules [MVP]" wrote: I just learned about this the other day. (I told you I was an Excel novice.) That will save me a lot of time at work! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to identify lower case vs upper case | Excel Worksheet Functions | |||
How to convert a column of text to upper and lower case? | Excel Discussion (Misc queries) | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
How do I change a column in Excel from upper case to lower case? | Excel Worksheet Functions | |||
How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) |