Remove Hard Return

[Stephen]

Hi All,

I've got a Text file I want to import to Excel but it has a  (a Har
Return in Text format) in it I want to delete before its imported int
excel. Is this possible and how do I go get rid of it.

Example;

A1 A2
Stephen dep1
Mark dep1
Jay dep1

Thanks in advange.

Stephe

 

[Stephen]

Sorry People, it looks like the Rectangular can't been seen if you vie
this post. It looks like [] in a text file.

Stephen

 

[steve]

you can loop through the text you imported looking for a
Chr(10)

then remove that carecter

-----Original Message-----
Sorry People, it looks like the Rectangular can't been seen if you view
this post. It looks like [] in a text file.

Stephen

*Hi All,

I've got a Text file I want to import to Excel but it has a  (a Hard
Return in Text format) in it I want to delete before its imported
into excel. Is this possible and how do I go get rid of it.

Example;

A1 A2
Stephen dep1
Mark dep1
Jay dep1

Thanks in advange.

Stephen *

 

[Stephen]

I'll give it a try, thanks.

Stephen

*you can loop through the text you imported looking for a=20
Chr(10)=20

then remove that carecter=20

-----Original Message-----
Sorry People, it looks like the Rectangular can't been=20 seen if you view
this post. It looks like [] in a text file.

Stephen

 

[David McRitchie]

I would suggest TRIMALL macro at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
simply removing a CHR(10) in your code will result in
some words joined together as one.
---
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

I'll give it a try, thanks.

Stephen

*you can loop through the text you imported looking for a=20
Chr(10)=20

then remove that carecter=20

-----Original Message-----
Sorry People, it looks like the Rectangular can't been=20 seen if you view
this post. It looks like [] in a text file.

Stephen

*Hi All,
=20
I've got a Text file I want to import to Excel but it=20 has a =0C (a Hard
Return in Text format) in it I want to delete before=20 its imported
into excel. Is this possible and how do I go get rid=20 of it.
=20
Example;
=20
A1 A2
Stephen dep1
Mark dep1
=0CJay dep1
=20
Thanks in advange.
=20
Stephen *

*