how to get rid of all Tabs, carriage returns, or new line characters

[siemian]

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

[David McRitchie]

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

"siemian" <jjj@de.de> wrote in message news:dr8keh$4bt$1@atlantis.news.tpi.pl...
> 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
>
>