How to remove Middle text in Excel cells(having Large database)

Help Activities
,
1

new sheet.xlsx (10.3 KB)
I want to delete Middle text in each row of “Address Column”, For example : I need to delete “Shell Mumbai” in “Red Cross Shell Mumbai Maharashtra” , “The tree” in “Nest In The Tree hydd Cafe Area”, “next stop” in “tin factory next stop in bnglr”…Likewise the middle text and text beside it needs to be deleted in each row of the Address Column.So, can anyone please suggest me idea or give any sample workflow so that I can solve this problem.

2

For your reference, I need the output like thisUpdated Sheet.xlsx (10.0 KB)