Separation based on semi-colon
I need a code that separates a string based on the semi-colon.
Eg: John;James;Sam;Tyler;Warden - (in a single cell)
O/P : John
The O/p should be in different cells one below the other.
can anyone help me on this?