View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
susanmgarrett susanmgarrett is offline
external usenet poster
 
Posts: 1
Default Replacing Printable Ascii Codes

I have a column that contains a text log of search terms entered in a search
box. The column contains the code for the printable ascii characters (like
%20 for space, %24 for $, etc), but does contain the actual alpha/numeric
characters

Is there a function in each that will allow me to change the codes to the
actual characters or will I have to create a massive search and replace macro
for the 34 codes.