Thread: find a number in a cell
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default find a number in a cell
That works for the cells that have (SO) or (OT) at the end but it gives
me
a #value! if the cells end with a number. Any ideas? Thanks.

Did you see my 2nd posting in this thread... it has the modified formula you
want.

Rick

Reply With QuoteReply With Quote