Pasting Text from Outlook into 1 Excel cell

[giantwolf]

Hi,

Any ideas how I can paste text (which has blank lines between it) fro
an outlook email into 1 cell in an Excel spreadsheet. When I try th
line spaces mean that the text appears in different cells.

Thanks in advance,

g

 

[giantwolf]

Don't worry I've sorted it myself after searching previous threads -
should have done that first!

 

[David McRitchie]

You could try pasting to notepad, the copying from notepad and
pasting into Excel.

A bit easier and would probably do the same would be to install
and use PureText (http://www.SteveMiller.com/apps)

 

[Dave Peterson]

Did you just paste into the the formula bar?

Don't worry I've sorted it myself after searching previous threads -
should have done that first!