| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | |||
| Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
| 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 does excel store new line and line feed characters? | Excel Programming | |||
| special character - line feed | Excel Programming | |||
Threaded Mode
