Home 
Search 
Today's Posts 
#1




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! 
#2




Formula to pull first word from text string in a column
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! 
#3




Formula to pull first word from text string in a column
=LEFT(A2,FIND(" ",A2)1)
You may want to add some error handling if there isn't always more than one word. =IF(ISNUMBER(FIND(" ",A2)1),LEFT(A2,FIND(" ",A2)1),A2)  David Biddulph "CrisT" wrote in message news 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! 
#4




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! 
#5




Formula to pull first word from text string in a column
You may want to add some error handling
Another way: =LEFT(A1,FIND(" ",A1&" ")1)  Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =LEFT(A2,FIND(" ",A2)1) You may want to add some error handling if there isn't always more than one word. =IF(ISNUMBER(FIND(" ",A2)1),LEFT(A2,FIND(" ",A2)1),A2)  David Biddulph "CrisT" wrote in message news 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! 
#6




Formula to pull first word from text string in a column
I think your data must start in row 1, whereas Luke's formula assumed it
started on row 2. It gave you the correct result first time because you have Subaru on the first two rows. Just change Luke's references from A2 to A1 in T1, and then copy down again. Hope this helps. Pete "CrisT" wrote in message ... 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! 
#7




Formula to pull first word from text string in a column
Hey, that's neat Biff !!
Pete "T. Valko" wrote in message ... You may want to add some error handling Another way: =LEFT(A1,FIND(" ",A1&" ")1)  Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =LEFT(A2,FIND(" ",A2)1) You may want to add some error handling if there isn't always more than one word. =IF(ISNUMBER(FIND(" ",A2)1),LEFT(A2,FIND(" ",A2)1),A2)  David Biddulph "CrisT" wrote in message news 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! 
#8




Formula to pull first word from text string in a column
Hi,
There is nothing wrong with the stated approach. First make sure that the formula is refering to the cell on the same row as the formula. In other words =LEFT(A1,Find(" ",A1)1) should be entered in B1, if the first entry is in A1.  If this helps, please click the Yes button Cheers, Shane Devenshire "CrisT" wrote: 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! 
#9




Formula to pull first word from text string in a column
May I ask, what does the '&" "' do? Thanks for your help too!
"T. Valko" wrote: You may want to add some error handling Another way: =LEFT(A1,FIND(" ",A1&" ")1)  Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =LEFT(A2,FIND(" ",A2)1) You may want to add some error handling if there isn't always more than one word. =IF(ISNUMBER(FIND(" ",A2)1),LEFT(A2,FIND(" ",A2)1),A2)  David Biddulph "CrisT" wrote in message news 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! 
#10




Formula to pull first word from text string in a column
Thanks everyone for your help, I had tried to figure this one out on my own
by searching some old posts but I'm still trying to understand some of "language" of formulas and got frustrated. Thanks again! "Shane Devenshire" wrote: Hi, There is nothing wrong with the stated approach. First make sure that the formula is refering to the cell on the same row as the formula. In other words =LEFT(A1,Find(" ",A1)1) should be entered in B1, if the first entry is in A1.  If this helps, please click the Yes button Cheers, Shane Devenshire "CrisT" wrote: 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! 
Reply 

Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Converting a text word or text string to a number  Excel Discussion (Misc queries)  
pull numbers from text string  Excel Discussion (Misc queries)  
variable text value within string formula required to sum column  Excel Worksheet Functions  
Formula to extract a specific word from text string  Excel Worksheet Functions  
Pull last word from a text string in Excel  Excel Worksheet Functions 