Notifications
Clear all
Topic starter
I Have a list of 10 Addresses. I want to Separate Village and city into 2 columns by using Formula. Do not use Data Tools or text to column.
Posted : 09/07/2021 10:19 am
Hello Reehan,
How you write an address differs, so what do your address list look like?
Br,
Anders
Posted : 09/07/2021 1:45 pm
Topic starter
File attached
Posted : 10/07/2021 3:39 am
One way would be like this:
For village:
=MID(B5,10,FIND(",",B5)-11)
For city:
=TRIM(MID(B5,SEARCH("City",B5)+5,LEN(B5)))
Posted : 10/07/2021 4:35 am
