sorting data with ;

J

jason2444

have a data sheet in one column the cell contains data like this
V8; 5.7; gas;CARB;4BBL;N;J;
V8; 5.7; diesel;CARB;4BBL;N;J;
I need to grab everything to the left of the 3rd ; ie. V8; 5.7; gas

any suggestions?
 
Top