I have an online form, the results of which are submitted as email to the recipient. The email that shows up to the recipient looks like this:
Name: Joe Smith
Address: 123 Cherry Lane
City: Los Angeles
Submit: Submit
Here's my question. How do I import this text into Excel so the field names ("Name", "Address", etc.) show up in, say, column A and the field entries ("Joe Smith", "123 Cherry Lane", etc.) show up in column B?
I am successful in this endeavor if I copy the email text, paste it into notepad (or any other text editor), save it as a .txt file, then import to Excel, indicating a colon as the delimiter. Is there a more direct way to do this?
Any help is greatly appreciated!
Name: Joe Smith
Address: 123 Cherry Lane
City: Los Angeles
Submit: Submit
Here's my question. How do I import this text into Excel so the field names ("Name", "Address", etc.) show up in, say, column A and the field entries ("Joe Smith", "123 Cherry Lane", etc.) show up in column B?
I am successful in this endeavor if I copy the email text, paste it into notepad (or any other text editor), save it as a .txt file, then import to Excel, indicating a colon as the delimiter. Is there a more direct way to do this?
Any help is greatly appreciated!