The ColdFusion equivalent to cr/lf is chr(10) & chr(13). Try it. It might work.
Thank you, Dan. That addressed the cr/lf issue perfectly. The AutoFilter looks like it will be the tough one if it is even possible. I found a solution that involves updating the POI on CF 9 and below but we are on CF 10.