Extract Text from Variable Length of Data

[shaikhrulez]

Hello everyone,

Please refer to attached file, need to extract text in RED color.

Eg-1) INWARD REMITTANCE 000007943542 /006/004 IDEAL FOOD INGREDIENTS FZE / REF/Invoice Payment/ Value DATE, 01/02/2017 - S84667422

Expected result : IDEAL FOOD INGREDIENTS

Eg-2) INWARD REMITTANCE 0267701909161654 RENAISSANCE CAPITAL DUBAI LTD 8 1560705822 RFB97527991 1/REF/AUGUST 2016 CHARGES Value DATE, 20/09/2016 - S22048430

Expected result: RENAISSANCE CAPITAL DUBAI LTD

Thanks.

 

[rahulshewale1]

hii,

please find the attached solution using vba.

http://stackoverflow.com/questions/...olor-from-a-cell-with-text-of-multiple-colors

thanks
Rahul shewale

 

[shaikhrulez]

hii,

please find the attached solution using vba.

http://stackoverflow.com/questions/...olor-from-a-cell-with-text-of-multiple-colors

thanks
Rahul shewale

I think I did a mistake in narrating the question.

The actual situation doesn't have text in red color, I used red color in above example just to make illustration easier.

I simply need to extract text from this sort of data.

Thanks.

 

[Marc L]

Hi !

Without any logic to achieved your need, it's only a manual way …
​

 

[bosco_yip]

Hi,

1] A mega formula just base on your provided data

2] Please refer to the attachment

Regards