| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ?
Hi
Imported Text in cells are formatted with 3 line feed characters. If you use clean() it deletes the characters and puts the text into one line. I need to be able to delete the Chr(10) and keep the formatting by a macro if possible. This file is needed to be uploaded into SAP which doesn't like CHR(10). Presently the only way to do this is to go to the end of each line and manually delete the three CHR(10) and all works well as the formatting stays the same. I have tried Substitute and Find and replace, Clean() but it always ends up in single line.... Hope someone can help.... Thanks Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate: Multi-Line Cell with 2 single line cells | Excel Worksheet Functions | |||
| Fonts & Line Feed in a Cell | Excel Discussion (Misc queries) | |||
| How can I insert a line feed in the text in an EXCEL cell? | Excel Discussion (Misc queries) | |||
| How to put line feed in a cell using a character not Alt/Enter | Excel Discussion (Misc queries) | |||
| How do I get rid of line feed characters in wrapped text? | Excel Discussion (Misc queries) | |||
Threaded Mode
