Importing data into Excel spreadsheet

Hello All,

I receive emails from students that come formatted like below. I want to import the text from these emails into an Excel spreadsheet. So far, the only way I know how to do it is to copy and paste the text from the email into notepad and then arrange the text so that it is all on one line like in notepad and then import that data into a spreadsheet. The problem is that the text I gather in the emails is formatted vertically as opposed to horizonal, which is how I want it presented in the Excel spreadsheet. For example, this is some text that I want to import:

STUDENTNAME=Kris Johnson
GENDER=F
INSTITUTION=Marquette University
STUDENTSTREET=1236 S. Lenox Street
STUDENTCITY=Milwaukee
STUDENTSTATE=WI
STUDENTMAILCODE=53207
STUDENTCOUNTRY=United States of America
STUDENTPHONE=415-735-2535
STUDENTEMAIL=kris.johnson@mu.edu
GRADEPOINTAVG=3.2
RACEETHNICITY=Native American
GRADTERM=Winter
GRADYEAR=2009
MAJOR=Political Science
MINOR=Spanish

I want it imported so that this information is displayed horizontally across cells in Excel, not vertically. So far the only way I have found to do this is to hit delete between each word in notepad so that all the information is on the same line and then in the text import wizard manually putting in the spaces between the words rather than choosing delimited when I import it. I then choose "do not display data" for the categories, such as "name gender and institution", so that only the student's responses are imported.

I was wondering if anyone knows of a faster way I can import this data so that it appears horizontally not vertically in Excel without having to go through all these steps.

Any tips would be greatly appreciated! Thanks!

Here's how I would do it.
From the email, copy
Open Excel and Paste Special >text starting in A2
Go to Data>Text to Columns>Delimited > choose "Other" and =
This will put your field names in A and your values in B
Delete A
Copy your values. Go to A1 (which should be empty)
Paste Special > Transpose.
You can do the first part in a blank sheet and transpose them into the proper row in your database sheet.

Any questions? Does this work for you? You could record it as a macro to shorten it even more but try this first.

ChemistB