View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
QDZF QDZF is offline
external usenet poster
 
Posts: 7
Default CAN I REPLACE NON-PRINTING CHAR(127) WITH A SYMBOL?

HAVE A FILE WITH A STRING OF TEXT BROKEN BY CHAR(127). I WOULD LIKE TO BREAK
THAT STRING AT EACH OCCURENCE OF CHAR(127). EASIEST WAY I COULD THINK OF WAS
TO REPLACE IT WITH A SYMBOL AND THEN USE TEXT TO COLUMNS. IS THERE A BETTER
WAY THAN THIS?