thank you all dear expert. I apologies, I miss a condition: the "new line " (enter key) if present I wanted to translate to space (" ") so that it reads in as continues seperated by comma. for example: have: abc,def new line, ghi,jkl,mno ,pqr stuw,xyz want: abc def new line ghi jkl mno pqr stuw xyz
... View more