Cleaning vba strings to summarize values

Names of data items are often inconsistent. This video shows an example of how VBA can be used to resolve inconsistencies so that data may be summarized.