Home |
Search |
Today's Posts |
#16
![]() |
|||
|
|||
![]()
"Alan Beban" wrote...
.... Unless I misunderstand, we already know from the OP's 3rd posting in this thread that it is the case. He made it clear that in Ryan Townhomes, the builder's name is Ryan and Townhomes is a suffix; and that in KB Home the builder's name is KB Home and Home is not a suffix. Then it's the same situation as parsing surnames from a list of peoples from many original nationalities but with inappropriate English capitalization rules applied. E.g., Charles Der Ruud Van Der Aalter Nguyen Van Tieu You come up with a rule to handle all these correctly, and you may have a prayer handling general company names which follow even fewer rules. [This is rhetorical. It's theoretically possible if there's a sufficiently complete rules base, but it'd be expedient to use an approach that works 80-90% of the time and correct the rest manually.] |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate a column by extracting unique values from another column? | Excel Worksheet Functions | |||
Count Unique Values | Excel Worksheet Functions | |||
Extract AutoFilter Column Values? | Excel Discussion (Misc queries) | |||
Count number of Unique values | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |