Using REPLACE function in Excel
 

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

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