Extract String and Display

[sureshsonti]

Hello,

I am trying extract just the vendor name from MATERIAL PLANT VENDOR field to VENDOR field

example:
SAND PL 01 -BALDWIN REDI MIX from this I only need text after the dash or hyphen BALDWIN REDI MIX. It should extract any data after the dash or hyphen

I have attached the spreadsheet.

Thanks again

 

[bosco_yip]

Duplicated-post

Don't open a new post, please stick to the original :

https://chandoo.org/forum/threads/extract-string-from-a-cell-and-display.39585/

This post closed.

Regards
Bosco