Thread: If I use 10 macro is ok but if I use 10: Auckland City Depot it is
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
  
Posts: 2,510
Default If I use 10 macro is ok but if I use 10: Auckland City Depot i
Hi again,

I should have included insert your case like this and you will get a match.

Case Left("10: Auckland City Depot", 20)

--
Regards,

OssieMac


Reply With QuoteReply With Quote