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?