I pasted a text file of columns and rows but it was all combined into a single entry A1. How do I break the column into separate rows?
Also…How can I move data from A1 into a new column B1? I tiedy to cut and paste but There is no B! to past into.
Afterthought… If I insert commas into the text can I load it as a csv file? How would I do that?
How did you do this? Try clicking this arrow and selecting one of the available insert options
Do you mean a text table? Then I suggest starting with the RTF option