[Solved] EXCEL: How to separate words on Excel

by


There’s Text to Columns, using + as a delimiter. That’s probably the quickest way.

Select the data, then go to Data –> Text to Columns. Choose “Delimited”, using a + delimiter. If you want, choose a destination (that’s optional, you can just click “Finish” which will overwrite the current data).

enter image description here

Alternatively, you can use LEFT() and RIGHT().

To get parts left of the +: 

LEFT(A1,SEARCH("+",A1)-1)

and right of the +:

RIGHT(A1,LEN(A1)-SEARCH("+",A1))

2

solved EXCEL: How to separate words on Excel