INDEX(COLLECT()) function to pull partial data

Jayy S.

I'm using an INDEX(COLLECT()) function to pull data from cross sheet reference; however, is there a way to pull partial data from the reference cell?

For example, the reference cell is "Molecular Division" but I only want to pull "Molecular" into the target cell.