Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#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. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Will the Excel WEEKNUM function become ISO 8601 compliant? | Excel Worksheet Functions | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Event hundler to control the Excel function arguments | Excel Worksheet Functions |