See screenshot:įormula: Remove everything after the second occurrence comma Then drag the Fill Handle to apply the formula to other cells. Select a blank cell to output the result, copy the below formula into it, and press Enter key. To remove all after the nth occurrence character from cells, you need to: You can change the ' ,' and 2 number to any character and occurrence position number as you need. In the formulas, B5, ' ,' and 2 number mean that all contents after the second occurrence comma will be removed from cell B5.Ģ.
Formula: Remove everything before the second occurrence comma
