About 5 months ago, I posted a mini-article entiteled "Improving the InStr Function". Here is the link to that article (which I also posted to some Excel groups as well)... https://lnkd.in/eCAnVKXR ...

When you want to aggregate values in a table where a single field contains multiple values, you can use the InStr function in a select query to separate them, and then perform aggregation using an ...

The INSTR function searches for the first occurence of a search STRING within a base string and returns the position it was found. The start% position had to be at ...