Formula to pull first word from text string in a column
Thank you Luke, it does work. I'm sorry I should have mentioned that I
wanted to run this formula down column "T". When I ran the formula this is
what I got for the rest of the rows:
subaru WRX subuaru
subuaru STI Jeep
Jeep Wrangler Jeep
Jeep Grand Cherokee subaru
subaru WRX subuaru
subuaru STI Jeep
Jeep Wrangler Jeep
Jeep Grand Cherokee #VALUE!
CrisT
"Luke M" wrote:
assuming your data is in column A.
=LEFT(A2,FIND(" ",A2)-1)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"CrisT" wrote:
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!
|