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?

Try this in any spare column, assumin data strts in A1 and copy down

=LEFT(SUBSTITUTE(A1,";","/",3),FIND("/",SUBSTITUTE(A1,";","/",3),1)-1)

HTH

"jason2444" wrote:

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?

AWSOME thanks

"Toppers" wrote:

Try this in any spare column, assumin data strts in A1 and copy down

=LEFT(SUBSTITUTE(A1,";","/",3),FIND("/",SUBSTITUTE(A1,";","/",3),1)-1)

HTH

"jason2444" wrote:

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?

Hi
Hope this formula works. = Right(A1;14). I assume the formular is called
"Right", I do not have the english version, but, there is a formular that
counts and leaves out the number of signs that you choose, and then return
everything left of the 3rd in a given cell. In danish it's Right.
--
Therese


"jason2444" skrev:

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?