Basically I have a VBA macros that pulls parsed data from emails in a specified outlook folder. It pulls a Price ($x.xx) and a name which are then both used in a vlookup in an accounting spreadsheet.
The problem Im having is that when I parse the name, I have to pull everything between "Shipping Address:" and "United States". That returns a string that looks like this:
John Doe380 W 23RD STSAN BERNARDINO, CA 92405-3718
if I select the cell and click the "wrap text" button it shows up like this:
380 W 23RD ST
SAN BERNARDINO, CA 92405-3718
SO, HOW DO I only parse that first line that has the name and isolate it. Or even run a quick macro to trim just down to the first line?