Remove set of texts or numbers or anything after certain string

Dear Anyone,
i have the following data
BABASONS, JUFFAIR, BH 20.562
LULU HYPERMARKET, DANA MALL, BH 20.211
SANA INTERNATIONAL - SALM, MANAMA, BH 2.010
VIVA, FSIDDIQUI.CS, BH 1.250

I need the result to be
BABASONS, JUFFAIR
LULU HYPERMARKET, DANA MALL
SANA INTERNATIONAL - SALM, MANAMA
VIVA, FSIDDIQUI.CS

which is the formula to remove anything found after the last comma.

if your text is in D4
place this is the cell you want the answer

Please Login or Register  to view this content.

Thanks a lot