Hey Excel Gurus,
How are you today?
I have a text in cell that looks something like
New York;Paris;London;Dubai
I want to extract each city in a different cell..
Hence , the city that comes before the first semi colon goes to A1, similarly the city coming before second semi colon and after the first semi colon should be in B2, and so on and so forth.
.
Much appreciation and thanks.
How are you today?
I have a text in cell that looks something like
New York;Paris;London;Dubai
I want to extract each city in a different cell..
Hence , the city that comes before the first semi colon goes to A1, similarly the city coming before second semi colon and after the first semi colon should be in B2, and so on and so forth.
.
Much appreciation and thanks.