software

have a file in one column each cell has something like this V8; 5.4;
GAS;FI;MFI;S;3;
need to write a formula in another cell to get V8; 5.4; GAS how do I get it
to grab everything to the left of the 3rd ;


to the left:=MID(A1,1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot; ,A1),99)) 1,99)) FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,A1) 1,99 )) FIND(quot;;quot;,A1) 1)

to the right:=MID(A1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,A 1),99)) 1,99)) FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,A1) 1,99)) FIND(quot;;quot;,A1) 3,99)or you could select the column and do Data, Text to Columns, delimited
on ; and then join the relavant cells together

--

jason2444 Wrote:
gt; have a file in one column each cell has something like this V8; 5.4;
gt; GAS;FI;MFI;S;3;
gt; need to write a formula in another cell to get V8; 5.4; GAS how do I
gt; get it
gt; to grab everything to the left of the 3rd ;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=532067I need it to only grab everything to the left of the specified ; without
setting a number of characters to grab after the ;
because I will need different amount of characters per line
V8; 5.7; GAS;CARB;4BBL;N;J; V8; 5.7; GAS
V8; 5.7; Diesel;CARB;4BBL;N;J; V8; 5.7; Die

can this be done?

quot;Bryan Hesseyquot; wrote:

gt;
gt; to the left:
gt;
gt;
gt; =MID(A1,1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot; ,A1),99)) 1,99)) FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,A1) 1,99 )) FIND(quot;;quot;,A1) 1)
gt;
gt; to the right:
gt;
gt;
gt; =MID(A1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,A 1),99)) 1,99)) FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,A1) 1,99)) FIND(quot;;quot;,A1) 3,99)
gt;
gt;
gt; or you could select the column and do Data, Text to Columns, delimited
gt; on ; and then join the relavant cells together
gt;
gt; --
gt;
gt; jason2444 Wrote:
gt; gt; have a file in one column each cell has something like this V8; 5.4;
gt; gt; GAS;FI;MFI;S;3;
gt; gt; need to write a formula in another cell to get V8; 5.4; GAS how do I
gt; gt; get it
gt; gt; to grab everything to the left of the 3rd ;
gt;
gt;
gt; --
gt; Bryan Hessey
gt; ------------------------------------------------------------------------
gt; Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
gt; View this thread: www.excelforum.com/showthread...hreadid=532067
gt;
gt;


In the column that you wish the result to be, (say column D)

in cell D1 post the formula shown for 'to the left' - ie:

=MID(A1,1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;
,A1),99)) 1,99)) FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,A1) 1,99 )) FIND(quot;;quot;,A1) 1)

and formula-drag this to the end of your data

this should provide what you want.

--jason2444 Wrote:
gt; I need it to only grab everything to the left of the specified ;
gt; without
gt; setting a number of characters to grab after the ;
gt; because I will need different amount of characters per line
gt; V8; 5.7; GAS;CARB;4BBL;N;J; V8; 5.7; GAS
gt; V8; 5.7; Diesel;CARB;4BBL;N;J; V8; 5.7; Die
gt;
gt; can this be done?
gt;
gt; quot;Bryan Hesseyquot; wrote:
gt;
gt; gt;
gt; gt; to the left:
gt; gt;
gt; gt;
gt; gt;
gt; =MID(A1,1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot; ,A1),99)) 1,99)) FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,A1) 1,99 )) FIND(quot;;quot;,A1) 1)
gt; gt;
gt; gt; to the right:
gt; gt;
gt; gt;
gt; gt;
gt; =MID(A1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,A 1),99)) 1,99)) FIND(quot;;quot;,MID(A1,FIND(quot;;quot;,A1) 1,99)) FIND(quot;;quot;,A1) 3,99)
gt; gt;
gt; gt;
gt; gt; or you could select the column and do Data, Text to Columns,
gt; delimited
gt; gt; on ; and then join the relavant cells together
gt; gt;
gt; gt; --
gt; gt;
gt; gt; jason2444 Wrote:
gt; gt; gt; have a file in one column each cell has something like this V8;
gt; 5.4;
gt; gt; gt; GAS;FI;MFI;S;3;
gt; gt; gt; need to write a formula in another cell to get V8; 5.4; GAS how do
gt; I
gt; gt; gt; get it
gt; gt; gt; to grab everything to the left of the 3rd ;
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Bryan Hessey
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Bryan Hessey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=532067
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=532067