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
 
Back
Top