Hello there, I have attached my example workbook. In cell A1 I have a text string, with a comma separating each entity.
I would like to extract and stack each entrant as shown in the example. So the name will appear in B and the price in C.
Could someone help with the formula needed to extract and order in this way from the text string in A1
Bookmarks