Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

Copper Contributor

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.

3 Replies




With Office 365 or Excel for the web you can apply this formula.

text to columns.png



Alternatively with 365:


=TEXTSPLIT(TEXTJOIN(",",,A2:A4), "; ", ",",,,"")