software

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,quot;;quot;,quot;/quot;,3),FIND(quot;/quot;,SUBSTITUTE(A1,quot;;quot;,quot;/quot;,3),1)-1)

HTH

quot;jason2444quot; wrote:

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

AWSOME thanks

quot;Toppersquot; wrote:

gt; Try this in any spare column, assumin data strts in A1 and copy down
gt;
gt; =LEFT(SUBSTITUTE(A1,quot;;quot;,quot;/quot;,3),FIND(quot;/quot;,SUBSTITUTE(A1,quot;;quot;,quot;/quot;,3),1)-1)
gt;
gt; HTH
gt;
gt; quot;jason2444quot; wrote:
gt;
gt; gt; have a data sheet in one column the cell contains data like this
gt; gt; V8; 5.7; gas;CARB;4BBL;N;J;
gt; gt; V8; 5.7; diesel;CARB;4BBL;N;J;
gt; gt; I need to grab everything to the left of the 3rd ; ie. V8; 5.7; gas
gt; gt;
gt; gt; any suggestions?
gt; gt;

Hi
Hope this formula works. = Right(A1;14). I assume the formular is called
quot;Rightquot;, 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.
--
Theresequot;jason2444quot; skrev:

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