Thread
:
sorting data with ;
View Single Post
#
1
Posted to microsoft.public.excel.misc
jason2444
Posts: n/a
sorting data with ;
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?
Reply With Quote