Do some Excel Work

I need an expert with knowledge in excel (macros/VBS/formulas) to develop a string break down solution and separate the string values based on given keywords. This should be 1-2 hours project.

Details:

On the "Raw Data" in Column A, there is a list with Vehicle Titles that I want to break down in three columns - Make - Model - Remaining. The Make column is done, I need someone to strip the Car Model from each Title in column A and place it in Column D. The remaining values from the string (without the Make and Model) should be placed in column E. There is a list with the titles in Column B without the Make - you can work with that one as well if easier.

How the Title breakdown should be done.

1. The title string that should be broken down in Make, Model and Remaining is in "Raw Data" sheet Column A (or Column B, which is the same but without the make)

2. For every title the Make is extracted in Column C.

3. IMPORTANT! - Match the Make from "Raw Data" Column C with the makes in "Data to match" sheet Column A.

4. When there is a match, get the corresponding Model from "Data to match" sheet Column B.

5. Check if that Model is contained in the string in "Raw Data" sheet Column A (or Column B).

6. If yes, place the model value in "Raw Data" column D. If not leave it blank or #N/A.

7. Remove the matched Makes and Models from "Raw Data" Column A (or if you work with Column B - remove the match Model from it).

8. Place the remaining values in "Raw Data" Column E.

Examples of what the final output should be can be seen in "Example" sheet.

I need this to be done with a Macro, VBS or Formula. And the provided project should contain the source as well so that the solution can be applied again and again on future files.

Data Entry Data Processing Excel

Project ID: #6326804

About the project