Then use the formula recommended for you to replace the characters. Then split the text into cells again. Read detailed instructions here: How to split cells in Excel: Text to Columns, Flash Fill and formulas.
Then use the formula recommended for you to replace the characters. Then split the text into cells again. Read detailed instructions here: How to split cells in Excel: Text to Columns, Flash Fill and formulas.