CODEWITHSUNDEEP
excel
AlexWithYou
AlexWithYou

Reputation: 429

Excel split column by words

enter image description here It seems there are some formatting problem here, I can't get the table format correct, so I attached a screenshot on preview.

Upvotes: 0

Views: 88

Answers (1)

WeAreOne
WeAreOne

Reputation: 1343

In B1 write this formula and drag it to the right and down.

=MID($A1;COLUMNS($B$1:B1);1)

Change semicolon to comma first, if your Excel version uses commas instead.

enter image description here

Upvotes: 1

Related Questions