Search formula for first word

[Manolocs]

Hello, is there a way to extract the entire cell content in the same row if the first word of the next cell is beginning with the word "car"?
Thanks in advance for your help

[/IMG]

 

[Peter_SSs]

Is this what you mean? Each formula copied down.

Excel Workbook
	B	C	D
2	Honda		Honda
3	Ford		Ford
4	Car blue	Car blue
5	Infinity		Infinity
6	Lexus		Lexus
7	Car yellow	Car yellow
8	Nissan		Nissan
Split column

 

[Manolocs]

Hi Peter_SSs Fantastic that is what I needed, in case of "car" is not the first word how could be the answer? Do you want me to make a new question?
Thanks a lot

 

[Peter_SSs]

Hi Peter_SSs Fantastic that is what I needed,

Glad it helped.

in case of "car" is not the first word how could be the answer? Do you want me to make a new question?

It depends. If the new question is an extension of this one or is closely related, you can continue here. If it is a completely different question, start a new thread.


You should also investigate section B of the Forum Use Guidelines for posting sample data. Posting an image like you did doesn't encourage helpers as they cannot copy/paste to their own worksheets. You can't expect them to do a lot of typing to set up samples to test.

 

[Manolocs]

Just found in this forum... Thanks for your time