In Excel, how do I seperate data that is imported into one column

  • Thread starter Thread starter Pablo
  • Start date Start date
P

Pablo

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
 
YOu could click on DATA in the menu, select IMPORT EXTERNAL DATA and select
new WEB QUERY to bring the data into a workbook.

If you prefer the copy & paste method you can select your copied text, click
DATA on the menu and select TEXT TO COLUMNS to parse the data.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Formula for seperating data 1
Link Data from several colums into a single one and sort 1
Splitting a cell into rows instead of columns 12
Importing data from Excel worksheet into Excel template 2
comma delimited not seperating into columns 1
Data sort seperate by blank row 1
how do i seperate data from one column into two seperate ones in . 2

Back
Top