Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting data with ;
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting data with ;
Hi
Hope this formula works. = Right(A1;14). I assume the formular is called "Right", I do not have the english version, but, there is a formular that counts and leaves out the number of signs that you choose, and then return everything left of the 3rd in a given cell. In danish it's Right. -- Therese "jason2444" skrev: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
sorting data and automatic graphs | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Automatically sorting data | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) |