First word in a cell

[daffy]

Hi Guys

Is this possible?

What i would like to do is.

If the first word in a cell for example says "travel" then display the content of another cell, if it does not then just leave the other cell blank.

Its a job sheet that says travel to ???????? or travel to ******
So i need to pick out just the word "travel"

There are other line in the spreadsheet that do not say travel at all so these to will be ignored.

This may be simple but i am stuck on it.

Thanks in advanced for any help.

Don

 

[Mike Blackman]

Hi,

Maybe something like this?

=IF(LEFT(A1,FIND(" ",A1)-1)="Travel",B1,"")

 

[baitmaster]

in a new cell3, try: =if(left([cell1],6)="travel",[cell2],"")

where [text] are your relevant cell references

 

[daffy]

Guys

Thanks for the quick responce.

Mike, Got yours to work no problem

Bait Master Could not seem too get your to work.

Thank you both for your help (it was much needed)

Don

 

[Peter_SSs]

Guys

Thanks for the quick responce.

Mike, Got yours to work no problem

Bait Master Could not seem too get your to work.

Thank you both for your help (it was much needed)

Don

Mike's solution included a check to make sure the first word was "Travel" rather than something like "Travelling". A simpler way to do that would be:
=IF(LEFT(A1,7)="Travel ",B1,"")

 

[daffy]

Peter

Thank you for your post.

Could you explain to me what the number 7 is for.

=IF(LEFT(A1,7)="Travel ",B1,"")

Thanks

Don

 

[Weaver]

LEFT(A1,7) refers to the first 7 characters in the string contained in cell A1

The idea being that "travel" is 6 letters and if the string started with "travelling" you'd still get a match, whereas comparing the first 7 characters and including the space after "travel " ensures this doesn't happen. If you want it to, go back to left(A1,6)="travel"

 

[daffy]

Thanks for making it clear.