sorting data with ;
AWSOME thanks
"Toppers" wrote:
Try this in any spare column, assumin data strts in A1 and copy down
=LEFT(SUBSTITUTE(A1,";","/",3),FIND("/",SUBSTITUTE(A1,";","/",3),1)-1)
HTH
"jason2444" wrote:
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?
|