Using REPLACE function in Excel

G

GarryG

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

Dave Peterson

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.
 
Top