LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 85
Default Hard Returns

I am moving data to Excel from SQL that contains hard returns in these text
fields. I need to remove the hard return values (they look like little
boxes) using VBA. I can do it manually by activating the cell and simply
deleteing them. The hard return still exists even when the symbol is
removed. That is what I need to do in code.

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Removing hard returns Janet Excel Discussion (Misc queries) 1 June 18th 08 06:44 PM
hard returns froggie Excel Discussion (Misc queries) 2 December 10th 07 07:50 PM
Trim for Hard Returns Andrew Excel Programming 7 November 8th 06 11:53 AM
Hard returns in a formula? PCLIVE Excel Worksheet Functions 5 February 8th 06 05:17 PM
how to remove hard returns, which show as little boxes eames.librarian Excel Discussion (Misc queries) 3 August 4th 05 07:46 PM


All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"