Help with copy/paste

[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!

 

[JE McGimpsey]

One way:

Click in the Formula box (in the Formula bar) first.

 

[Gord Dibben]

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

 

[David Biddulph]

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.

 

[yvmason]

One way:

Click in the Formula box (in the Formula bar) first.



- Show quoted text -

Thank you! It worked like a charm.