• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract TEXT values

Hi,

I have text in a cell as follows

GRAVEL PL 01 -VENDOR (PLANT 1).
I am trying to extract GRAVEL PL 01 into one cell, and VENDOR 1 into another cell, and PLANT 1 into another cell.

I have attached sample workbooks

Thanks
 

Attachments

  • chandooproblem.xlsx
    10.1 KB · Views: 4
Back
Top