Trying to take first word from a column & place this data into another column

[Stealth351]

I have a sheet that contains product descriptions starting with a brand name. I need to copy the first word from each row & deposit it into another column in the same row. Can this be done?

Here is an example, where i have manually copied the first two rows data into the second column:

[protonLeah]

There's no way for a formula to tell what constitutes a brand name. Your first example has two words separated by one space while the second has an abbreviation (word?) with no space.

[Stealth351]

Hi Ben,
Bad example on my part. Disregards the fact it is two words, if it was to bring the Team across i could use find & replace to fix the full name.

[shukla.ankur281190]

Hi Ben,
Bad example on my part. Disregards the fact it is two words, if it was to bring the Team across i could use find & replace to fix the full name.

Do you have brand list??? if yes then it can be possible through lookup & search function .

[Stealth351]

I could write a brand list if that would help.

[shukla.ankur281190]

I could write a brand list if that would help.

Please do as you said and i will give you solution...

[Raphaelp]

To find the the first word (i.e. everything before the first space) you do this:

=LEFT(A2,FIND(" ",A2)-1)

or if your excel has flash fill you just type in the first word and then click flash fill.

[Stealth351]

Thanks Raphaelp, that's exactly what i needed!