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
|