View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Kessel Andy Kessel is offline
external usenet poster
 
Posts: 5
Default Replacing alt-enter (think chr(10)) with other text

I'm a little out of practice and need some help.

I need a macro to replace chr(10) -( the result of using alt-enter when
editing a cell) in value cells with a string "xxxx" or whatever.

I know this is basically easy, but could use some help. I'm not sure
if I would have to navigate through all cells, and look one character
at a time and when I find this to replace it, or if there is another
way.

Certainly can't figure out how to do it with find and replace.

Thanks,

Andy Kessel