| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to separate Certain INFO from a Column
I have a bunch of products and i need to separate the brand of the products
For example: Grey Flannel Cologne by Geoffrey Beene for Men Lady Stetson Perfume by Coty for Women Envy Cologne by Gucci for Men Gucci Rush 2 Perfume by Gucci for Women Coty Musk Cologne by Coty for Men Tabu Perfume by Dana for Women Canoe Cologne by Dana for Men The brand is between by and for Grey Flannel Cologne by "Geoffrey Beene" for Men Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to separate Certain INFO from a Column
Try
=IF(ISERROR(FIND("by",A1)),"",LEFT(A1,FIND("for",A 1)-1)) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to separate Certain INFO from a Column
One crack ..
Assuming data running in A1 down In B1: =TRIM(MID(A1,SEARCH("by",A1)+2,SEARCH("for",A1)-SEARCH("by",A1)-2)) Copy down to extract the "brand" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Gmata" wrote: I have a bunch of products and i need to separate the brand of the products For example: Grey Flannel Cologne by Geoffrey Beene for Men Lady Stetson Perfume by Coty for Women Envy Cologne by Gucci for Men Gucci Rush 2 Perfume by Gucci for Women Coty Musk Cologne by Coty for Men Tabu Perfume by Dana for Women Canoe Cologne by Dana for Men The brand is between by and for Grey Flannel Cologne by "Geoffrey Beene" for Men Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to separate Certain INFO from a Column
Try search and replace function :
(if u still ned text other than the brand,- do it on a copy column) search for : *by[1 space] replace with : nothing then search for : [1 space]for* replace with : nothing "Max" skrev: One crack .. Assuming data running in A1 down In B1: =TRIM(MID(A1,SEARCH("by",A1)+2,SEARCH("for",A1)-SEARCH("by",A1)-2)) Copy down to extract the "brand" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Gmata" wrote: I have a bunch of products and i need to separate the brand of the products For example: Grey Flannel Cologne by Geoffrey Beene for Men Lady Stetson Perfume by Coty for Women Envy Cologne by Gucci for Men Gucci Rush 2 Perfume by Gucci for Women Coty Musk Cologne by Coty for Men Tabu Perfume by Dana for Women Canoe Cologne by Dana for Men The brand is between by and for Grey Flannel Cologne by "Geoffrey Beene" for Men Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to separate Certain INFO from a Column
=MID(A1,FIND("by",A1)+3,FIND("for",A1)-FIND("by",A1)-4)
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Gmata" wrote in message ... I have a bunch of products and i need to separate the brand of the products For example: Grey Flannel Cologne by Geoffrey Beene for Men Lady Stetson Perfume by Coty for Women Envy Cologne by Gucci for Men Gucci Rush 2 Perfume by Gucci for Women Coty Musk Cologne by Coty for Men Tabu Perfume by Dana for Women Canoe Cologne by Dana for Men The brand is between by and for Grey Flannel Cologne by "Geoffrey Beene" for Men Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching for info in a separate workbook | Excel Discussion (Misc queries) | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
| Use info in separate table file | Excel Discussion (Misc queries) | |||
| Excel Column-Can I separate info within a cell? | Excel Discussion (Misc queries) | |||
| Adding rows of different info from separate worksheets into summar | New Users to Excel | |||
Linear Mode
