Help with removing certain strings from cells

[sparkroms]

Hi, I am trying to do my inventory that I got from my supplier and the format for the item listings is "[brand name] Men's {description}". I was wondering if you guys could help me find a way to get that "men's" (or women's or unisex depending on the item) out of each cell and into a new column so that I could easily integrate a column for gender on my site. I would really appreciate if you guys can help me out. I dont know very much excel. I can only use stuff like RIGHT() and LEFT(). But I can learn very easily. Thanks!

[Biff]

Hi!

Try this:

A1 = [brand name] Men's {description}

B1 = formula:

=MID(A1,FIND("]",A1)+2,FIND("{",A1)-1-(FIND("]",A1)+2))

Biff

"sparkroms" <[email protected]> wrote
in message news:[email protected]...
>
> Hi, I am trying to do my inventory that I got from my supplier and the
> format for the item listings is "[brand name] Men's {description}". I
> was wondering if you guys could help me find a way to get that "men's"
> (or women's or unisex depending on the item) out of each cell and into
> a new column so that I could easily integrate a column for gender on my
> site. I would really appreciate if you guys can help me out. I dont know
> very much excel. I can only use stuff like RIGHT() and LEFT(). But I can
> learn very easily. Thanks!
>
>
> --
> sparkroms
> ------------------------------------------------------------------------
> sparkroms's Profile:
> http://www.excelforum.com/member.php...o&userid=25037
> View this thread: http://www.excelforum.com/showthread...hreadid=564543
>

[autosaviour]

Would using "text to columns" help you (using "space" as delimiter)? This
would push every word into a new column (good if brand name is only one
word). Then you could concatenate back together any multi word titles you
need. Or you could autofilter column for lines containing "men's", write
"men's" in new column, copy down and use find replace to replace " men's" in
the original column with "" (nothing) if you want it removed, repeat for
other groups.


"sparkroms" wrote:

>
> Hi, I am trying to do my inventory that I got from my supplier and the
> format for the item listings is "[brand name] Men's {description}". I
> was wondering if you guys could help me find a way to get that "men's"
> (or women's or unisex depending on the item) out of each cell and into
> a new column so that I could easily integrate a column for gender on my
> site. I would really appreciate if you guys can help me out. I dont know
> very much excel. I can only use stuff like RIGHT() and LEFT(). But I can
> learn very easily. Thanks!
>
>
> --
> sparkroms
> ------------------------------------------------------------------------
> sparkroms's Profile: http://www.excelforum.com/member.php...o&userid=25037
> View this thread: http://www.excelforum.com/showthread...hreadid=564543
>
>