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

Options
LEllis
LEllis ✭✭
edited 02/02/23 in Formulas and Functions

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.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!