Hello,

The =split( cell, "character") function would do this. You'll just have to make sure that you have enough columns to the right to accommodate this split.

For your example, you would need 3 blank columns to the right available.

Assuming cells are listed from A1:A4, to get the type of car, you'll need to split using a space character (" ") using the formula below.

=split(A1, " ")
This will result in
A1 = Suburu WRX in B1 = split(A1,"") and showing in B1 = Suburu C1=WRX

....

=split(A4, " ")
This will result in
A4 = Jeep Grand Cherokee in B1 = split(A4,"") and showing in B4 = Jeep C4=Grand D4 = Cherokee

I hope this helps!