In Excel, how do I seperate data that is imported into one column
Highlight the data then click on Data | Text-to-columns. This will
take you through 3 steps, where you can specify the delimiter, how to
treat each field of data, where to place the data once parsed etc.
Hope this helps.
Pete
On Dec 7, 1:46 pm, Pablo wrote:
When going online to import financial data I do a copy of all the data and
then a "Paste Special" "Text" and all the data comes in in one column and
seems de-limited by a space or tab. How do I sort so that data is in seperate
columns?
Paul M
|