(Solved) – Extracting Text from Cell using Excel VBA


I am looking to extract multiple text values from a column in Excel and populate another column with these text values.

To be more specific, I am looking to extract the STLS ticket numbers.

For example, one row may contain “ABCD-4, STLS-5644, ABBD-33, STLS-421”, another row may contain “ABB-567, STLS-56435” and another row may contain no STLS tickets.

What would be the best way to approach this problem?

Leave a Reply

Your email address will not be published. Required fields are marked *