Thread: If I use 10 macro is ok but if I use 10: Auckland City Depot it is
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Steved Steved is offline
external usenet poster
  
Posts: 519
Default If I use 10 macro is ok but if I use 10: Auckland City Depot i
Hello OssieMac from Steved

Thankyou very much.


"OssieMac" wrote:

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