Thread: Help with Right(Me.ListStoreIP.Column(0), 2)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default Help with Right(Me.ListStoreIP.Column(0), 2)
I think there is a way to find # and use the value to the right of the number
sign
Any help would be great
Tobacco Rd Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #112
Right(Me.ListStoreIP.Column(0), 2) = 12 Wrong
Reply With QuoteReply With Quote