convert vertical text file to horizontal and then export to Outlook Contact folder

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Java Hop - 27 Dec 2003 00:51 GMT

I have the following problem: I copied a vertical search results table (45 listings per page) and pasted into an Excel file. I know I have to define a name for a certain range in order to export the file to Outlook's contact folder. How can I do this? I'm thinking that the easiest way is to somehow paste the vertical table into a horizontal table format in Excel. Is there a way I can do this or can I convert the vertical information into horizontal format somehow

Thank you
javahop @ hotmail.com

Reply to this Message

Diane Poremsky [MVP] - 27 Dec 2003 01:17 GMT

paste special, transpose....

Signature

Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)

Outlook Tips: http://www.outlook-tips.net/
Search for answers: http://groups.google.com
Most recent posts to the Outlook newsgroups:
http://groups.google.com/groups?as_ugroup=microsoft.public.outlook.*&num=30

>I have the following problem: I copied a vertical search results table (45
>listings per page) and pasted into an Excel file. I know I have to define
[quoted text clipped - 6 lines]
> Thank you,
> javahop @ hotmail.com

Reply to this Message