Forum Discussion
EXCEL - How to create columns of data from one cell containing a semi-colon between multiple words.
I have a string of data like this in one cell. mailto:email address removed for privacy reasons;Cochran;Ralph;;02-17-2017;01-17-2024 I need each piece of the cell that is separated by a semi-colon ...
=IFNA(DROP(REDUCE("",SEQUENCE(ROWS(A2:A4)),LAMBDA(u,v,VSTACK(u,TEXTSPLIT(INDEX(A2:A4,v),";")))),1),"")
With Office 365 or Excel for the web you can apply this formula.