Does anyone know how i can get rid of emtpy lines in a text file:
I thought this might work - it doesn't :(
welcome any suggestions
k
=STRTOFILE(CHRTRAN(FILETOSTR("c:\mydir\m.txt"),CHR(13)+" ",' '),"c:\mydir\m.txt")
original text:
line 1 of text
line 2 of text
line 3 of text
line 5 of text
i would like converted to
line 1 of text
line 2 of text
line 3 of text
line 5 of text