| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 85992 | 2007-12-30 03:10:00 | Excel Formula - Detecting or Changing Case | GrahamB (750) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 625739 | 2007-12-30 03:10:00 | I have a very large list which is a mixture of Upper Case and Title Case. I need to either determine which cells have Upper Case, or reset all cells to Title Case. I know I can extract the data to WORD and change it but the data base is way to big, so I want, if possible, to mark the lines in which the last letter of the data field is Upper Case, (an IF statement following a LEN calculation?)then sort and extract to WORD only those cells needing a change. Is there a formula to check the case of a cell or letter, or alternatively, a way to reset a cell to Title Case? TFYH And Happy New Year! Regards GrahamB |
GrahamB (750) | ||
| 625740 | 2007-12-30 06:05:00 | this should do it support.microsoft.com set it up as a Macro then run it of course you need to change the range of cells the macro examines. |
beama (111) | ||
| 625741 | 2007-12-30 18:01:00 | Hi Graham Try this: =PROPER(A1) Andrew |
andrew93 (249) | ||
| 625742 | 2008-01-01 07:19:00 | Thanks Andrew93. That works well. Thanks beama for your suggestions, i will keep them on file for future use. I would still like a formula to determine if a letter is in Upper or Lower case? Any ideas? Regards Graham B |
GrahamB (750) | ||
| 625743 | 2008-01-01 10:02:00 | Hi Graham Try this: =IF(CODE(RIGHT(A1,1))>96,"lower","UPPER") I'm only testing the rightmost character per your original post but the Code part returns the ASCII code of the character - uppercase letters start at 65 and lowercase letters start at 97. Andrew |
andrew93 (249) | ||
| 1 | |||||