How can scrub/replace my text and split it so when I past into excel, it pastes into multiple columns?

I thought the \n function would do that, but any text that I have tried that with does not actually split into two columns; it pastes the entire, "xxxxx\nxxxxx" string into a single cell.

Apologies if this is more of an excel formatting question - I've searched and just can't find anything on it.