I have tried applying "PROPER" to the address, and it comes close, but is not quite what I am looking for.
For instance, the address was originally: 64875 234TH AVE CT SE
This is becoming far more complicated than I'd like it to be, but here we go.....
So, when cell B807 pulls its data from cell M576, the address is 64875 234TH AVE CT SE
When the formula is applied, =PROPER(M576) it comes up with 64875 234Th Ave Ct Se (Actual address not provided due to privacy of homeonwer)
The problem with this is that the Th after the 234, should be all lowercase.
The reason that this is becoming more complicated is that the Se should be all capitals like SE
So truly converting this to a combination of upper case when needed, lower case when needed and a combination of the two is needed.
Because streets, courts, avenues, etc should all be a combination of upper case for the abbreviation, the directions, such as South, South East, South West, etc should all be capitalized like S, SW, SE, NE, NW, etc but the
letters after the street name should be all lowercase like 68th, 43rd, 21st, etc. Is there a way to do this without using VBA?
I finally figured out how to use the xl2bb in excel. here is what I am looking to do.
For instance, the address was originally: 64875 234TH AVE CT SE
This is becoming far more complicated than I'd like it to be, but here we go.....
So, when cell B807 pulls its data from cell M576, the address is 64875 234TH AVE CT SE
When the formula is applied, =PROPER(M576) it comes up with 64875 234Th Ave Ct Se (Actual address not provided due to privacy of homeonwer)
The problem with this is that the Th after the 234, should be all lowercase.
The reason that this is becoming more complicated is that the Se should be all capitals like SE
So truly converting this to a combination of upper case when needed, lower case when needed and a combination of the two is needed.
Because streets, courts, avenues, etc should all be a combination of upper case for the abbreviation, the directions, such as South, South East, South West, etc should all be capitalized like S, SW, SE, NE, NW, etc but the
letters after the street name should be all lowercase like 68th, 43rd, 21st, etc. Is there a way to do this without using VBA?
I finally figured out how to use the xl2bb in excel. here is what I am looking to do.
ALAMODE WORKSHEET RE WORKING SHEET CALCULATIONS FOR APPRAISAL NARRATIVES AND IMPORTING DATA INTO APPRAISAL SOFTWARE.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
863 | PROPERTY INFORMATION | ||||
864 | PROPERTY ADDRESS | ||||
865 | |||||
866 | 64875 234TH AVE CT SE | 64875 234Th Ave Ct Se | |||
867 | Desired result | 64875 234th Ave Ct SE | |||
IMPORT PAGE |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B866 | B866 | =PROPER(A866) |