Data import, carriage return
 

Hi,

After I export addresses from our database to a .txt file.

When I open it in Excel
the address fields start a new row like below:
Name
Address1
Address2
Address3

Not the format I wanted
Name Address1 Address2 Address3

How to import the .txt to the correct columns?

If I open it in Notepad
When the Format - Word Wrap is selected, the appearance is the same as
Excel
When the Format - Word Wrap is unselecte, the Address1, Address2 and
Address3 are separated by a small square (I suspect it's a carriage
return)

Is there a way in Notepad to replace the small squares with a "!"?
Then hopefully Excel would import them with the right column, however,
the title of the column might not correctly lined up.

If I open it in Word, the appearance is similar as Excel.
If I Find "^p", I could find that at the end of every whole record
If I Find "^013", I could not only find that at the end of every whole
record, but also at the end of Address1, Address2...
Maybe there is a ASCII code for the small squares only?

At the moment, I could
In Word, replace the "^p" to "End***End", then replace the "^013"
to !, then replace "End***End" to "^p", save it as .txt.
In Excel open the .txt. copy of the column field alone to a new Excel,
save into tab deliminated, then open withe deliminator with Other "!",
then copy the columns back to the original file.
It's quite a work aroud.

I am sure there are better ways. Hopefully you could help.

Regards
Sam

Data import, carriage return
 

did you search for 010?


--


Gary


"Sam" wrote in message
oups.com...
Hi,

After I export addresses from our database to a .txt file.

When I open it in Excel
the address fields start a new row like below:
Name
Address1
Address2
Address3

Not the format I wanted
Name Address1 Address2 Address3

How to import the .txt to the correct columns?

If I open it in Notepad
When the Format - Word Wrap is selected, the appearance is the same as
Excel
When the Format - Word Wrap is unselecte, the Address1, Address2 and
Address3 are separated by a small square (I suspect it's a carriage
return)

Is there a way in Notepad to replace the small squares with a "!"?
Then hopefully Excel would import them with the right column, however,
the title of the column might not correctly lined up.

If I open it in Word, the appearance is similar as Excel.
If I Find "^p", I could find that at the end of every whole record
If I Find "^013", I could not only find that at the end of every whole
record, but also at the end of Address1, Address2...
Maybe there is a ASCII code for the small squares only?

At the moment, I could
In Word, replace the "^p" to "End***End", then replace the "^013"
to !, then replace "End***End" to "^p", save it as .txt.
In Excel open the .txt. copy of the column field alone to a new Excel,
save into tab deliminated, then open withe deliminator with Other "!",
then copy the columns back to the original file.
It's quite a work aroud.

I am sure there are better ways. Hopefully you could help.

Regards
Sam