Pasting into mutiple cells

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

Guest

I often cut and paste into excel from a text (.txt) document or email that
has a column of numbers or words. When I paste, it all goes into the same
cell in Excel. How can I make each column paste into its own column in Excel
 
I'd paste into a single column. Then use data|text to columns to parse the data
into separate columns.

And since excel likes to help, you'll see that excel remembers those parsing
rules the next time you paste.

This assumes that you haven't:
1. closed and reopened excel
2. done a different data|text to columns
or
3. imported a different text file

Each of these will change the behavior (resetting or remembering different
rules)
 
Hi,

In such situation you must select the checkbox next to column A and then
paste the data. Based on the delimiters you have specified in the text file,
Microsoft Excel will populate the worksheet accordingly.

Challa Prabhu
 

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

Why this paste result? 4
retain custom date format "text" when pasting or reformatting data 2
Creating emailing list from column of addresses 2
Cut and Paste Text with CRLF into Single Cell 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do you paste a list of bulleted text from a word doc. into exc 2
copying/pasting accurately from a Word table (carriage returns) 1
Copy paste data from a column to a row 0

Back
Top