LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 41
Default 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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching for info in a separate workbook mailrail Excel Discussion (Misc queries) 0 October 4th 07 09:16 PM
Link info in one cell to info in several cells in another column (like a database) hansdiddy Excel Discussion (Misc queries) 1 February 22nd 06 02:27 AM
Use info in separate table file MnO Excel Discussion (Misc queries) 2 February 2nd 06 09:13 AM
Excel Column-Can I separate info within a cell? Stan Excel Discussion (Misc queries) 4 April 28th 05 09:53 PM
Adding rows of different info from separate worksheets into summar Barry P New Users to Excel 1 February 8th 05 02:47 PM


All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"