View Single Post
  #1   Report Post  
JRR
 
Posts: n/a
Default Search and replace character with in excell cell

I am converting data from another application into Excel. There are certain
characters (representing ASCII 253) that need to be replaced with the value
of <alt+enter which is the internal newline + carriage return for data
within a single cell of a sheet. I cannot get the replace function to take
the new value. Who has any suggestions about this?