Below is a mocked up file format that I have. The length is variable. Number of rows within each cell is also variable. Each row within the cell doesn't have a delimiter such as a comma. I had used Alt+Enter to create a row within each cell.
My end goal is to get a count in column B which based on the sample below should be 9.
Is there an easy way to get that information without macro?
My end goal is to get a count in column B which based on the sample below should be 9.
Is there an easy way to get that information without macro?
Row 1 | A5678 Cheatsheet D8796555 |
Row 2 | Snapshot5667 Pic345654332 |
Row 3 | Hello097685 F1234587 |
Row 4 | ABC R8697089 |