Formula to extract words separated by semicolons in a cell (Excel)


To totally unlock this section you need to Log-in


Login

A field in Excel contains words separated by semicolons, for example:

A1 = save;the;national;treasure;for;good

How can I apply Excel text formulas to produce separate words from this field in another fields? For example:

A2 should contain a formula to get the first word ("save") A3 should contain a (different) formula to get the second word ("the") etc.

To totally unlock this section you need to Log-in


Login

1 thought on “Formula to extract words separated by semicolons in a cell (Excel)”

Comments are closed.