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

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 ;