EXCEL - How to create columns of data from one cell containing a semi-colon between multiple words.

Question

I have a string of data like this in one cell.

email address removed for privacy reasons;Cochran;Ralph

I need each piece of the cell that is separated by a semi-colon put into a separate column, instead of all three pieces of data all in one column.

lorenzo · Answer

Hi&nbsp;BethP107&nbsp;&nbsp;One way =&gt;&nbsp;Split text into different columns with the Convert Text to Columns WizardAnother if you run 365 =&gt; TEXTSPLIT function

oliverscheurich · Answer

BethP107&nbsp;=IFNA(DROP(REDUCE("",SEQUENCE(ROWS(A2:A4)),LAMBDA(u,v,VSTACK(u,TEXTSPLIT(INDEX(A2:A4,v),";")))),1),"")&nbsp;With Office 365 or Excel for the web you can apply this formula.

lorenzo · Answer

BethP107&nbsp;&nbsp;Alternatively with 365:=TEXTSPLIT(TEXTJOIN(",",,A2:A4), "; ", ",",,,"")

Forum Discussion

EXCEL - How to create columns of data from one cell containing a semi-colon between multiple words.

Share

Resources