Thread: Can search see characters following ^~ in excel ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Geoff Thomas Geoff Thomas is offline
external usenet poster
  
Posts: 1
Default Can search see characters following ^~ in excel ?
My spreedsheet looks for unix printer aliases and matches them to numeric
code values. However excel cannot see past "^~" characters and hence does not
find a match eg "5CQ-MKPCTCC^~CC^~5CQ-CCCAMPBW" will only see
"5CQ-MKPCTCC^~". Can you tell me if there is a work around?
Reply With QuoteReply With Quote