Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |