want to know if it is possible to write a formula that will check one column
for specified variables and depending on the variable fill in a seperate
column with the text assigned to that variable

like if column A1 contains the words Chevy,Chevrolet then put the word Chevy
in A2 or if contains the words dodge then put the word dodge in A2.