Split Text With Excel Formula Into Two Columns

To split text with excel function, you can use combination of four excel function.
Here are list of function that we will use:
LEFT
RIGHT
LEN
FIND

In cell A1 type text “Fuel+Car”. So we want to split text “Fuel” in B1 and “Car” in C1. Picture below

After in cell B1 put formula LEFT(A1;FIND(“+”;A1)-1)

And finally in cell C1 put another one RIGHT(A1;LEN(A1)-FIND(“+”;A1)). That’s it!