Email Body Message to Split to Fields

[webmax]

Hi,

I am getting the Email Body Message for a Enquiry (Attaching the Input in the yellow color in the excel sheet). But when i try to paste in excel the body is paster in one single cell.

There date to be filled in the four fields ie Name, Email Address , Telephone Number and Message accordingly (Attaching the Output in the orange color in the excelsheet).

Can you guide how to split based on the Body Message received to the 4 fields.

Regards
Shahul

 

[AliGW]

Which version of Excel do you have?

 

[vletm]

webmax
One possible way ...

 

[webmax]

2010

 

[bosco_yip]

In B2, formula copied across :

=TRIM(LEFT(SUBSTITUTE(MID(LEFT($A2,FIND("Copyright",$A2)-1),FIND(B$1,$A2&B$1)+LEN(B$1)+1,90),C$1,REPT(" ",90)),90))

Regards
Bosco