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