database to excell

[brakemach1ne]

I'm successfully to launching excell in the browser window
using my database queries to fill in the rows in the spreadsheet.

The problem I'm having is that if one of my fields has a value with a "return" in it the data jumps down to the next row in the spread sheet at the return. I've tried to "explode()" the field but that only removes the first instance of the "return" and not the rest.

Any advice would be mega!
thnxinadvance

[PyroX]

Try:

$cell=trim(ereg_replace("\n","",$cell));

or

$cell=trim(ereg_replace("\n","",$cell));

( Not sure about the \ or \ , also \r\n or \c )

[brakemach1ne]

thnxamillion

[Weedpacket]

'xcept trim(str_replace()) would be faster.