Haseeb, I truly apologize, but I did a mistake while trying to explain to you. I have been trying to make your formula work before I bothered you again, but I give up.
In Column A I have:
Superfast Car [Lexus]
Boat in the Sea [Whaler,Blue]
Wooden Table [Brown]
Superfast Car [Lexus]
Superfast Car <--------- If this one has no brackets, therefore it should still show "Car" in Column D.
It should show "Car" not "Superfast Car".
Bookmarks