| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get rid of line feed characters in wrapped text? | Excel Discussion (Misc queries) | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
| Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions | |||
| Macro - Skipping a line | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
