G Guest Jun 17, 2005 #1 Is it possible to Replace multiple lines of text in an Excel Cell as a single action - including the line returns?
Is it possible to Replace multiple lines of text in an Excel Cell as a single action - including the line returns?
D Dave Peterson Jun 17, 2005 #2 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.
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.
