Not sure if Replace takes three args.
Try this: lccleanstr = rows.item(0).ToString().Replace(chr(13) & chr(10),"")
I use C# so pardon me if syntax is not invalid but you get the idea.
>Thanks,
>that worked although I had tried
>lccleanstr = replace(rows.item(0),chr(13) & chr(10),"")
>and that didnt work..
>
>Thanks again
>
>Paul
- Jayesh