View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kamini Kamini is offline
external usenet poster
 
Posts: 8
Default inserting line break within a row



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