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

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

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

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" wrote in message ...
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