Search formula for first word

Manolocs

Active Member
Joined
Mar 28, 2008
Messages
339
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 :)

o78uc6.jpg
[/IMG]
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
Is this what you mean? Each formula copied down.

Excel Workbook
BCD
2Honda Honda
3FordFord
4Car blueCar blue
5InfinityInfinity
6LexusLexus
7Car yellowCar yellow
8NissanNissan
Split column
 

Manolocs

Active Member
Joined
Mar 28, 2008
Messages
339
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,809
Messages
5,598,202
Members
414,218
Latest member
speedbit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top