| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contains or Includes
Thanks, that works!
Jim "Alan Beban" wrote in message ... Jim Berglund wrote: I'm trying to create a mailing list and have a list containing Mr, Ms, Miss, Mrs, Dr, etc. Some names have no salutations. I want to use a macro that looks for the first name if and after one of these surnames occurs. I tried multiple IF's, as below? =IF(LEFT(A31,3)="Mrs","Mrs",IF(LEFT(A31,4)="Miss", "Miss",IF(LEFT(A31,2)=OR("Mr","Ms","Dr"),LEFT(A31, 2),""))) The frst part works for Mrs * Miss, but the OR section gives me a #Value error. I there a better way? Jim Berglund =IF(LEFT(A31,3)="Mrs","Mrs",IF(LEFT(A31,4)="Miss", "Miss",IF(OR(LEFT(A31,2)="Mr",LEFT(A31,2)="Ms",LEF T(A31,2)="Dr"),LEFT(A31,2),""))) Alan Beban |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter includes extra row | New Users to Excel | |||
| average that includes estimates if data not available | Excel Worksheet Functions | |||
| Using a macro that includes 2 worksheets | Excel Discussion (Misc queries) | |||
| Getting a range that includes alternate rows only | Excel Programming | |||
| =max(range includes #N/As) | Excel Worksheet Functions | |||
![Jim Berglund[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
