how to insert column data or tab delimited data into a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that has a header and then a section of 3 columns in tab delimited format. I want to copy the 3 column field and paste it into a table. I created a table of 3 columns with Xn of rows, when I paste it, it will not drop instinctively into the 3 columns. Everything is pasted in one column. How do I do this.
 
Paste the report into regular text, without trying to set up the table
first. Then, with the text still selected, go to Table > Convert > Text to
Table. The dialog should already show that it will create 3 columns
separated at tabs; if it's set any other way, change it. Click OK and you'll
have your table.
 

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

VBA - retrieve data on last create named range from previous inserted named range 0
inserting table data from a Word document into an Access table 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Copy paste a table column into another table 4
insert file in word 2007 not working correctly 1
Paste tab delimited data into separate fields 6
Word table into tab-delimited ormat? 1
multiple column text in a word 2003 table 12

Back
Top