Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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?
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Soozie,

Are you sure you want the address fields combined? I've had to mess around
with more applications where that had been done, in order to separate the
address components.

Rather than working with codes, you might want to concatenate some cells
with a formula:
=A2 & " " B2 & " " & C2 & ", " D2 & " " E2

You might need to describe your data more fully to us. Give an example.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"soozie" wrote in message
...
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?



  #3   Report Post  
soozie
 
Posts: n/a
Default

Thanks for this Earl,

My database has already been set up with the address in one field and it
would be very complicated to change this now.

I have been sent a load of data which I have formatted in Word.

Here is an example:

Zinc Unit U20
Acton Business Centre
School Rd
Old Oak Common
London NW10 6TD 020 8838 3636

In order to split the data into separate fields I have placed a tab after
the company name, manual line breaks between the address lines, a tab before
the postcode and a tab before the telephone number. But Excel doesn't
recognise the line breaks. So I've replaced the line breaks with commass so
as to keep the address in one field when importing using tabs as the
delimiters. But I then want to pull the data into Filemaker and would like to
find a way of replacing the commas with line breaks.

I suppose you may be right that if I put all the address lines into separate
fields and then used a formula to join them together that might be the way to
go, but I still can't work out how to get the line breaks in!

Any other thoughts?

Sue

  #4   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Soozie,

I'm not sure about what you're telling me about the Word file and the tabs
and line breaks. From the top, you have a txt file, and your objective is
to get it into Excel. Open the txt file in NotePad, and tell us what's
there. Give us an example or two. Descriptions are often ambiguous. Then
tell us exactly how you need it in Excel, with an example or two.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"soozie" wrote in message
...
Thanks for this Earl,

My database has already been set up with the address in one field and it
would be very complicated to change this now.

I have been sent a load of data which I have formatted in Word.

Here is an example:

Zinc Unit U20
Acton Business Centre
School Rd
Old Oak Common
London NW10 6TD 020 8838 3636

In order to split the data into separate fields I have placed a tab after
the company name, manual line breaks between the address lines, a tab
before
the postcode and a tab before the telephone number. But Excel doesn't
recognise the line breaks. So I've replaced the line breaks with commass
so
as to keep the address in one field when importing using tabs as the
delimiters. But I then want to pull the data into Filemaker and would like
to
find a way of replacing the commas with line breaks.

I suppose you may be right that if I put all the address lines into
separate
fields and then used a formula to join them together that might be the way
to
go, but I still can't work out how to get the line breaks in!

Any other thoughts?

Sue



Reply
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 08:43 PM
Can I use Find and Replace all with Hyperlinks? HandsOnManager Excel Discussion (Misc queries) 0 February 15th 05 08:39 PM
find replace cursor default to find box luffa Excel Discussion (Misc queries) 0 February 3rd 05 01:11 AM
macro to Find Replace in Excel Nurddin Excel Discussion (Misc queries) 7 January 3rd 05 05:29 AM
VB Find and Replace Bony_Pony Excel Worksheet Functions 10 December 6th 04 06:45 PM


All times are GMT +1. The time now is 08:37 PM.

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

About Us

"It's about Microsoft Excel"