Count the number of times a text value appears in a single cell (or alternatively, split the cell)

Hi Smartsheets community,

I have a column of data with cells that contain text values that I need to count. For example, the cell in one of these columns may contain something like:

"ABC123 - TEXT TEXT TEXT

ABC008 - TEXT TEXT TEXT"

The two lines of "ABC" text are separated by a carriage return.

I'm trying to count how many times each "ABC000" value occurs in my spreadsheet. So I need to know how many times we find ABC001, ABC002, and so on. Sometimes, there is only one "ABC" value in a cell, sometimes there are two or more.

Any suggestions on how to do this? Smartsheets does not seem to have a SPLIT function, where I could split out the values via the carriage return and then attempt to count them that way.

Thanks in advance.