Copy from Outlook and paste in Excel cell

I have Windows Media Center 2005 (XP Pro) and Office 2003.

When I receive an E-mail using Outlook and I have multiple lines that
I want to copy from Outlook to one Excel cell, each line is pasted
into a separate cell in that column. If I have text such as:

Product: any product
Version: V1.0
Order Number: 99939393

I want to paste these three lines in once Excel cell. Currently I do
this manually by entering Alt-Enter after each line. Is there any way
I can select all three lines and paste them as such in only one cell?

thank you,

Click in the Formula bar (or double-click the cell to enter Edit mode) and
paste instead of selecting the cell.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/tr...295841033.aspx

"Clamorous" <Joseph.Sander@goodrich.com> wrote in message
news:2d931d75-76e4-4621-8900-3dcb083ed199@1g2000prg.googlegroups.com...
>I have Windows Media Center 2005 (XP Pro) and Office 2003.
>
> When I receive an E-mail using Outlook and I have multiple lines that
> I want to copy from Outlook to one Excel cell, each line is pasted
> into a separate cell in that column. If I have text such as:
>
> Product: any product
> Version: V1.0
> Order Number: 99939393
>
> I want to paste these three lines in once Excel cell. Currently I do
> this manually by entering Alt-Enter after each line. Is there any way
> I can select all three lines and paste them as such in only one cell?
>
> thank you,

Thank you Beth.
---------------------------------

On Apr 8, 1:21*pm, "Beth Melton" <bmel...@mvps.org> wrote:
> Click in the Formula bar (or double-click the cell to enter Edit mode) and
> paste instead of selecting the cell.
>
> ~~~~~~~~~~~~~~~
> Beth Melton
> Microsoft Office MVPhttps://mvp.support.microsoft.com/profile/Melton
> What is a Microsoft MVP? *http://mvp.support.microsoft.com/gp/mvpfaqs
>
> Guides for the Office 2007 Interface:http://office.microsoft.com/en-us/tr...295841033.aspx
>
> "Clamorous" <Joseph.San...@goodrich.com> wrote in message
>
> news:2d931d75-76e4-4621-8900-3dcb083ed199@1g2000prg.googlegroups.com...
>
>
>
> >I have Windows Media Center 2005 (XP Pro) and Office 2003.
>
> > When I receive an E-mail using Outlook and I have multiple lines that
> > I want to copy from Outlook to one Excel cell, each line is pasted
> > into a separate cell in that column. If I have text such as:
>
> > Product: any product
> > Version: V1.0
> > Order Number: 99939393
>
> > I want to paste these three lines in once Excel cell. Currently I do
> > this manually by entering Alt-Enter after each line. Is there any way
> > I can select all three lines and paste them as such in only one cell?
>
> > thank you,- Hide quoted text -
>
> - Show quoted text -

You're welcome. :-)

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/tr...295841033.aspx

"Clamorous" <Joseph.Sander@goodrich.com> wrote in message
news:1dd7f157-326c-4f53-9769-50855e058dec@q24g2000prf.googlegroups.com...
Thank you Beth.
---------------------------------

On Apr 8, 1:21 pm, "Beth Melton" <bmel...@mvps.org> wrote:
> Click in the Formula bar (or double-click the cell to enter Edit mode) and
> paste instead of selecting the cell.
>
> "Clamorous" <Joseph.San...@goodrich.com> wrote in message
>
> news:2d931d75-76e4-4621-8900-3dcb083ed199@1g2000prg.googlegroups.com...
>
>
>
> >I have Windows Media Center 2005 (XP Pro) and Office 2003.
>
> > When I receive an E-mail using Outlook and I have multiple lines that
> > I want to copy from Outlook to one Excel cell, each line is pasted
> > into a separate cell in that column. If I have text such as:
>
> > Product: any product
> > Version: V1.0
> > Order Number: 99939393
>
> > I want to paste these three lines in once Excel cell. Currently I do
> > this manually by entering Alt-Enter after each line. Is there any way
> > I can select all three lines and paste them as such in only one cell?
>
> > thank you,- Hide quoted text -
>
> - Show quoted text -