For example, I have the following list in cell A1:
“Coffee, cream, sugar, tea”
I am trying to copy all the text before the second or third instance of the comma into an adjacent cell.
To extract the text before the second instance of the comma, use the ff. formula:
where the 2 represents the comma instance number
The result: Coffee, cream