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!
=LEFT(A2,FIND(" ",A2)-1)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
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" <Cr...@discussions.microsoft.com> wrote in message
news:DF295315-D059-4376...@microsoft.com...
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
Another way:
=LEFT(A1,FIND(" ",A1&" ")-1)
--
Biff
Microsoft Excel MVP
"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:49664904$1...@glkas0286.greenlnk.net...
Just change Luke's references from A2 to A1 in T1, and then copy down again.
Hope this helps.
Pete
"CrisT" <Cr...@discussions.microsoft.com> wrote in message
news:AD2BB897-7FBB-4B6C...@microsoft.com...
Pete
"T. Valko" <biffi...@comcast.net> wrote in message
news:%23dPKsZc...@TK2MSFTNGP03.phx.gbl...
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
Thanks again!
--
Rick (MVP - Excel)
"CrisT" <Cr...@discussions.microsoft.com> wrote in message
news:FC71BF08-FB77-4044...@microsoft.com...
--
Biff
Microsoft Excel MVP
"Pete_UK" <pash...@auditel.net> wrote in message
news:Onra1ccc...@TK2MSFTNGP02.phx.gbl...
A1 = Jeep
=LEFT(A1,FIND(" ",A1)-1)
That formula will return an error because FIND can't find a space character
in the string. To prevent the error we append a space character: A1&" "
=LEFT(A1,FIND(" ",A1&" ")-1)
A1 = Chevy Camaro
=LEFT(A1,FIND(" ",A1&" ")-1)
That string does contain a space character and the space character that gets
appended is basically ignored because FIND will find the *first* space
character in the string.
--
Biff
Microsoft Excel MVP
"CrisT" <Cr...@discussions.microsoft.com> wrote in message
news:FC71BF08-FB77-4044...@microsoft.com...