Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with removing certain strings from cells
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with removing certain strings from cells
Hi!
Try this: A1 = [brand name] Men's {description} B1 = formula: =MID(A1,FIND("]",A1)+2,FIND("{",A1)-1-(FIND("]",A1)+2)) Biff "sparkroms" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with removing certain strings from cells
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing text strings in cells | Excel Discussion (Misc queries) | |||
Removing $$ Reference in cells | Excel Worksheet Functions | |||
removing the word (blank) from pivot table cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |