Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "Dave Peterson" wrote: Or use ctrl-j RagDyeR wrote: Hold down <Alt, And type 0010 Using the numbers on the Num keypad, *not* the numbers under the function keys. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "edspyhill01" wrote in message ... I am trying to replace all commas with a newline character. What do I put in the Replace field? -- Dave Peterson Neither solution worked. I'm using the "Find and Replace" menu under Edit -- Replace. I have several fields in one cell separated by commas. I would like to substitute a new line character for each comma to create a short list in each cell. Example: From: user707@unix-mail, deliverable, mailer, ether, host, unix-mail.<domain, user, user707@unix-mail.<domain To: user707@unix-mail deliverable mailer ether host unix-mail.<domain user user707@unix-mail.<domain Thank you, Ed S. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using replace box to change a character into a CR (Alt-Enter char) | Excel Discussion (Misc queries) | |||
Replace or Substitute for COMBIN function | Excel Discussion (Misc queries) |