Split up a cell by every ;

Originally Posted by AliGW

Yes, sure it can, but it means a two-stage process, whereas the other two solutions offered are one-stage.

@AlphaFrog - your VBA solution was not being referred to - it was AB33 and Sktneer's proposals.

You have a brilliant future Ali!