software

hello

i have an excel document.
inside a lot of text
how can i get rid of all tabs, carriage returns and new lines characters
that could be in this documents in all fields?

thanks in advance for help
See the TrimAll macro and look at the comments
www.mvps.org/dmcritchie/excel/join.htm#trimall
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;siemianquot; gt; wrote in message ...
gt; hello
gt;
gt; i have an excel document.
gt; inside a lot of text
gt; how can i get rid of all tabs, carriage returns and new lines characters
gt; that could be in this documents in all fields?
gt;
gt; thanks in advance for help
gt;
gt;