Case - Wild Card search

[AlanAnderson]

Hi,
I need to process a column of fleet numbers. If the number starts with CH I need to copy it to one file, if it starts with F copy to another if neither I have to ignore it.

Can Excel 2003 handle wild card searching ? Eg. :

Case CH* ...
Case F* ....
Case else .. nothing

Regards,

Alan

Typical fleet numbers CH01, CH78, CH 87, F107, F99,

 

[mikerickson]

You might prefer an If...ElseIf...EndIf construction

If Left(FleetNumber, 2) = "CH Then
    rem do something
ElseIf Left(FleetNumber, 1) = "F" Then
    Rem do something else
End If

 

[AlanAnderson]

Hi Mike,

Thanks so much for speedy, ver helpful reply.

This forum is fantastic!

Regards,

Alan