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

--
Message posted from http://www.ExcelForum.com

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

Stephen


Stephen wrote:
*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 importe
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

--
Message posted from http://www.ExcelForum.com

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


Stephen wrote:
*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 *


---
Message posted from http://www.ExcelForum.com/

.

I'll give it a try, thanks.

Stephen



steve wrote:
*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


Stephen wrote:
*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 *


---
Message posted from http://www.ExcelForum.com/

.


--
Message posted from http://www.ExcelForum.com

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

"Stephen " wrote in message ...
I'll give it a try, thanks.

Stephen



steve wrote:
*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


Stephen wrote:
*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 *


---
Message posted from http://www.ExcelForum.com/

.
*


---
Message posted from http://www.ExcelForum.com/