How to remove new line chars from multi-line Excel file?

Hi
I have to read Excel files. I use  phpExcelReader. Some cells in the Excel files are multi-line, ie. they were done using "ALT+ENTER". I need a regex to remove these new-line characters from the strings that the excel reader returns to me.

Thank you
tr5
tr5Asked:
Who is Participating?
 
hernst42Connect With a Mentor Commented:
You can try (if those delimiters are newlines):
preg_replace('/(\n|\r)/', '', $text);
0
 
tr5Author Commented:
Thank you
0
All Courses

From novice to tech pro — start learning today.