View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Manually? And did you use alt-enter to force the new line within the cell?

Edit|replace
what: (yourstringhere)
with: (yournewstringhere)
replace all

When you're typing in the strings, you can use ctrl-j to represent the newline
in the cell.

Don't look at the screen--'cause it may not look like you're typing anything
after the ctrl-j, but you are.

GarryG wrote:

Is it possible to Replace multiple lines of text in an Excel Cell as a single
action - including the line returns?


--

Dave Peterson