Hi Good Afternoon from Sri Lanka,

I have lots and lots of addresses as Data, out of that I need to remove/omit the part which states the City and state along with the rest of the contents like Zip No. etc ANYTHING & EVERYTHING which follows afterwords.

Sample given below for your reference & also has been attached. Address Issue.xlsx

Please give me a hand.

Many Thanks.

THE DATA What I need
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM, Zhongshan, Guangdong, China JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM,
SKDJNCSDCNSC, LSCLCJSDLJCLKCLSCLKSJC, Zhongshan, Guangdong, China Book Special Tour SKDJNCSDCNSC, LSCLCJSDLJCLKCLSCLKSJC,
SKDJN, LSCLCJSDLJCLKCLSCLKSJC, Zhongshan, Guangdong, China 528414 Book Special Tour SKDJN, LSCLCJSDLJCLKCLSCLKSJC,
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM, Zhongshan,.China JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM,
SKDJN, LSCLCJSDLJCLKCLSCLKSJC, Guangdong, China Book Special Tour SKDJN, LSCLCJSDLJCLKCLSCLKSJC,
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM, Zhongshan City,.China JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM,