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".