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