Please see the Mini-sheet below;
Only for columns A, B, C, F and G, how can I convert all words which are separated by a space... from all letters being UPPER CASE to only the first letter of each word being Upper Case and the rest of the letters in that word being lower case as in the following example.
ALL CAPS WORD
to
All Caps Word
I would be hugely grateful for the above but even better would be if there could be two exceptions;
The two exceptions are to leave the word as ALL CAPS if It is either LLC or INC.
You can probably imagine how appreciative and thankful I am for your help. Eddie
Only for columns A, B, C, F and G, how can I convert all words which are separated by a space... from all letters being UPPER CASE to only the first letter of each word being Upper Case and the rest of the letters in that word being lower case as in the following example.
ALL CAPS WORD
to
All Caps Word
I would be hugely grateful for the above but even better would be if there could be two exceptions;
The two exceptions are to leave the word as ALL CAPS if It is either LLC or INC.
You can probably imagine how appreciative and thankful I am for your help. Eddie
| MiniSheet4MrExcel.xls | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | OWNER1 | OWNr_aDRS | OWNR_CITY | OWNR_STATE | OWNR_ZP | PPTY_strt | PPTY_CITY | PPTY_STATE | PPTY_ZP | ||
| 2 | 999 CORTEZ BOULEVARD LLC | 4 AFBEN DR #85 | LOVELAND | GA | 80538 | 104 CORTEZ BLVD | WEEKI WACHEE | FL | 34613 | ||
| 3 | FALPONBSH SHFL I LLC | 3 BEFITENTIAL BLVD #201 | BALA CYNWYD | NY | 19004 | 237 COUNTY LINE RD | SPRING HILL | FL | 34609 | ||
| 4 | CHURCH IN THE CHRISTIAN INC | 7051 COUNTRY RD | WEEKI WACHEE | AL | 34613 | 3051 COUNTRY RD | WEEKI WACHEE | FL | 34613 | ||
| 5 | PERFELL FAMILY TRUST | 7116 CHEVIOT DR | LOS ANGELES | ND | 90064 | 756 SPRING HILL DR | SPRING HILL | FL | 34606 | ||
Merge This Version | |||||||||||
