Posted to microsoft.public.excel.programming

Stephen[_13_] Stephen[_13_] is offline

external usenet poster

Posts: 1

Remove Hard Return

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
remove a hard return in a cell	slickrok	Excel Discussion (Misc queries)	3	August 8th 07 04:08 PM
Hard return	ttribble	Excel Worksheet Functions	4	June 19th 07 04:33 AM
Replace ; with hard return	Stephanie	Excel Discussion (Misc queries)	11	April 17th 07 10:11 PM
how to remove hard returns, which show as little boxes	eames.librarian	Excel Discussion (Misc queries)	3	August 4th 05 07:46 PM
hard return	alphadog47	New Users to Excel	2	February 26th 05 08:38 PM

All times are GMT +1. The time now is 12:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us