| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search and change without replacing-excel 2002
I am in the process of converting ID codes that are text. In column B i have
a variety of labels, ie.. shirt, sweater, hat. They repeat over and over again. I want column C to contain the word "summer" everytime "shirt" appears in Column B, "fall" everytime "sweater" apears and "winter" everytime "hat" appears. I do not want to get rid of the original column so I can not do a search and replace. The database already exists with the original labels only. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
search and change without replacing-excel 2002
Have you thought of copying column B and doing the search and replace just on
that copied column? Gord Dibben MS Excel MVP On Tue, 5 Jun 2007 10:01:01 -0700, islander wrote: I am in the process of converting ID codes that are text. In column B i have a variety of labels, ie.. shirt, sweater, hat. They repeat over and over again. I want column C to contain the word "summer" everytime "shirt" appears in Column B, "fall" everytime "sweater" apears and "winter" everytime "hat" appears. I do not want to get rid of the original column so I can not do a search and replace. The database already exists with the original labels only. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Can Vlookup search at left hand side of the table? | Excel Discussion (Misc queries) | |||
| Excel 2002: Can Vlookup formula search for data with two reference | Excel Discussion (Misc queries) | |||
| My Excel (2002) always opens on March 29 tab - how do I change it? | Excel Discussion (Misc queries) | |||
| Office 2002 excel search | Excel Discussion (Misc queries) | |||
| How do I print a Find-all search in Excel 2002? | Excel Discussion (Misc queries) | |||
Linear Mode
