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.

I figured out that my issue is dictated by the setting in "text to column" within excel. I just need to have that correlated to whatever my separator is in ClipboardFusion.