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!