Thread: How to test if the end character of a string is within a user-definedlist?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
T2net T2net is offline
external usenet poster
  
Posts: 7
Default How to test if the end character of a string is within a user-definedlist?
Hello,

I have a list in column which may look like

1
2
3a
3b
3g
56
67a
67c

I would like to keep only the rows which contains numbers or numbers +
a character.

Any idea?

Thanks, T2net

MS VB 6.3, Excel 2003, Win2000
Reply With QuoteReply With Quote