Not quite sure what you are after here. Imported (plain) text does not have
any formatting so there is no formatting to retain.

Do you want the all the text in a single cell with the 3 linefeeds (then
strip the linefeeds before uploading to SAP), or do you perhaps want text
between the linefeeds separate cells separated by two cells to simulate the
3 linefeeds, or something else.

Regards,
Peter T


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