View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default sorting data with ;


to the left:


=MID(A1,1,FIND(";",MID(A1,FIND(";",MID(A1,FIND(";" ,A1),99))+1,99))+FIND(";",MID(A1,FIND(";",A1)+1,99 ))+FIND(";",A1)+1)

to the right:


=MID(A1,FIND(";",MID(A1,FIND(";",MID(A1,FIND(";",A 1),99))+1,99))+FIND(";",MID(A1,FIND(";",A1)+1,99)) +FIND(";",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:
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 ;



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532067