Formula to pull first word from text string in a column
Hello, I was hoping someone could help me with a formula. I have a column in
a spreadsheet that has the following types of text (for example):
Subaru WRX
Subaru STI
Jeep Wrangler
Jeep Grand Cherokee
What I am looking for is a formula to pull the first word from the column
and put it in another column, say column T.
Thank you in advance!
|