Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Topic starter
I want to copy tabular data out of plain text and paste it into Excel, but I want it to recognise it as columnar data and paste it into columns. But it doens't do this. I want a wizard like the one when you import a CSV file, but for pasting.
Is this possible? I swear it used to work.
Posted : 19/08/2021 4:13 pm
Topic starter
Oh wait, I found it. Paste it in, then highlight and go to 'text to columns' in the data tab. As you were.
Posted : 19/08/2021 4:15 pm
Highlight the row label - grey bit at the edge - so the whole row is highlighted and ctrl-v to paste in?
Posted : 19/08/2021 4:16 pm
I think once you’ve pasted it in once and set up the text to columns, it’ll try do the same again for any further pasted data in that session
Posted : 19/08/2021 4:31 pm