I have text that I would like to paste text into a table. I’d like each line of text to get split across two columns. I know that I could probably get to this to work with a CSV import but I’m wondering if there’s a way to get the result I want with copy/paste.
Here’s an example of the text I would be pasting:
Line 1, Another boring day in the ocean.
Line 3, Another boring day in the ocean, SIR!
Here’s how I would like it to appear in a table:
Here’s how it actually appears in a table when I paste it:
I would either like the paste function to recognize the , and split the text into two cells at the comma (like a CSV import would do). Or I would like to paste the text then highlight column A and split the text at the comma into two columns.
Are either of these things possible?