Extract Information from a given cell using VBA

**Ravisca2003** · 04-28-2019, 04:27 AM

Dear All,

I have an online selling tie up with Amazon and I receive emails from Amazon when I receive any order. The text of body is like mentioned below. I am able to download such emails in excel sheet and below text is in a single cell.

I am looking for something in VBA where I can extract the required information from this text body into coloumns like Product code , Quantity, Shipping cost, Order value , etc .

Text to coloumn does not help here.
PLease suggest a way out

Dear [email protected],
Your Amazon.in order has been confirmed.
This e-mail includes all steps required for shipping and confirming your order.
Order ID: XXX-XXXXXXX-XXXXXXX
Please ship this product using Standard Delivery.
Item: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Condition: New
Listing ID: xxxxxxxxxxxxx

SKU: xxxxxxxxxxxxxxxxxxxxxxxxxxx

Quantity: 1

Order date: dd/Mm/yyyy
Buyer's price: INR xxxx

Tax: INR xx

Shipping: INR xx

Amazon fees: -INR xx

Your earnings: INR xx

**alansidman** · 04-28-2019, 04:31 AM

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

**Ravisca2003** · 04-28-2019, 04:52 AM

Please find the workbook containing two key sheets - Before and After. Before is the original extract without personal info. After sheet has yellow colored coloumns which I want to add with key information extract from mail body text from col 2.
Mapping.PNG