LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
soozie
 
Posts: n/a
Default Adding line breaks by using find and replace

I am trying to import data from a text file into an excel file. I want the
address to be all in one field rather than each line being in a separate
field. How can I replace the code ^l (or any other code) with a line break so
that the address appears correctly in the Excel file?
 
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
Using Find and Replace All HandsOnManager Excel Worksheet Functions 0 February 15th 05 07:43 PM
Can I use Find and Replace all with Hyperlinks? HandsOnManager Excel Discussion (Misc queries) 0 February 15th 05 07:39 PM
find replace cursor default to find box luffa Excel Discussion (Misc queries) 0 February 3rd 05 12:11 AM
macro to Find Replace in Excel Nurddin Excel Discussion (Misc queries) 7 January 3rd 05 04:29 AM
VB Find and Replace Bony_Pony Excel Worksheet Functions 10 December 6th 04 05:45 PM


All times are GMT +1. The time now is 01:15 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"