Title

Message

Confirm

<< DiscussionsReply

Formatting to paste into multiple columns in excel

22881
2 discussion posts
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.
Feb 23, 2022  • #1
22881
2 discussion posts
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.
Feb 24, 2022  • #2
Was this helpful?    
<< DiscussionsReply