Help with copy/paste

  • Thread starter Thread starter yvmason
  • Start date Start date
Y

yvmason

Morning. I want to paste multiple lines of text (recipe ingredients
list) in just one cell. I'm using Excel 2003 and what's doing is
pasting in multiple rows. Any help will be appreciated!
 
Is the text to be pasted from another application?

Paste the text into the formula bar, not into a cell.

Is the text from multiple cells in Excel?

You would need to write a formula to combine the cells into one cell.

=A1 & " " & B1 & " " & C1 & " " & D1 etc.


Gord Dibben MS Excel MVP
 
You don't say what you're pasting from, and what ASCII characters are
separating your lines.

You may find that if you select the cell and paste into the cell it will
split intio multiple rows, but if you paste into the formula bar it will
keep in one cell. Worth trying.
 
Back
Top