| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching a cells contents?
I've got a spreadsheet set up with a code in column A.
The code can have 2 forms, xxAxxxx, or xxBxxxx, where x is a number (eg 12A7586, 34B2875). In column C, I want a value of 1 or 2, depending on the code type in column A. Is it possibe to do this automatically, or do I have to go through them manually? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching a cells contents?
One way:
C1: =IF(MID(A1,3,1)="A",1,IF(MID(A1,3,1)="B",2,"Error" )) Or, if the code in A *has* to be either A or B in the third character: C1: = 2 - (MID(A1,3,1)="A") In article , SteW wrote: I've got a spreadsheet set up with a code in column A. The code can have 2 forms, xxAxxxx, or xxBxxxx, where x is a number (eg 12A7586, 34B2875). In column C, I want a value of 1 or 2, depending on the code type in column A. Is it possibe to do this automatically, or do I have to go through them manually? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching a cells contents?
Awesome.
Thank you very much! :-) "JE McGimpsey" wrote: One way: C1: =IF(MID(A1,3,1)="A",1,IF(MID(A1,3,1)="B",2,"Error" )) Or, if the code in A *has* to be either A or B in the third character: C1: = 2 - (MID(A1,3,1)="A") In article , SteW wrote: I've got a spreadsheet set up with a code in column A. The code can have 2 forms, xxAxxxx, or xxBxxxx, where x is a number (eg 12A7586, 34B2875). In column C, I want a value of 1 or 2, depending on the code type in column A. Is it possibe to do this automatically, or do I have to go through them manually? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
| Searching in another workbook for a string and returning with the contents of the cell next to it. | Excel Worksheet Functions | |||
| Searching for string in other cells | Excel Worksheet Functions | |||
| Is there any way of searching for duplicate cells? | Excel Discussion (Misc queries) | |||
| Searching for text in cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
