Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting line break with find and replace.
Hi
I have a text like this {"09/01/06 13:58:29 (esu,k):", "Request completed.", , "09/01/06 13:04:38 (p,e):", "add the role"} in a cell. I need to replace ", " with a single line break and ", , " with a double line break.This should all be within the same cell. The data in the cell should look like this. {"09/01/06 13:58:29 (esu,k): Request completed.Emailed user 09/01/06 13:04:38 (p, e): add the role "} within the same cell.. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BREAK A FIND/REPLACE OPERATION | Excel Discussion (Misc queries) | |||
How do I search and replace with a line break? | Excel Discussion (Misc queries) | |||
Alt + enter is not inserting a line break within a cell in Excel? | Excel Worksheet Functions | |||
Cells.Find for text w/ line break | Excel Programming | |||
Mass find replace - inserting a linebreak | Excel Programming |