Select the cells to fix (all of them???) and
format|cells|alignment tab|uncheck wrap text.



Luvsql wrote:

Neither of these seem to work. I did do the edit replace and it said it
did find items to replace, yet, the data still appears as

21 Progress AvenueUnit8 (eg) and if I double click on the cell, the row
height doubles

21 Progress Avenue
Unit 8

"Gord Dibben" wrote:

EditReplace

What: Alt + 0010(on the numpad)

With: nothing

Replace all.


Gord Dibben MS Excel MVP


On Mon, 19 Mar 2007 19:22:03 -0700, Luvsql
wrote:

I have spent a good 8 hours on this over the last week and CANNOT figure this
out. I have exported all our contacts out of Outlook to excel and the
addresses and some other fields are being exported with the carriage return,
but you cannot see the symbol. If I export to tab delimited file, the ones
with the carriage return are being put into 2 to 3 separate lines and makes
importing impossible.

For example, when I click on a field it actually appears as

123 Street
Unit 4

So if it's exported to text, it messes up everything. I have tried every
formula I can possible try and downloaded an add-on to view code and it says
"cell has an apostrophe prefix" but cannot see that either.

I can't even import into access and try to export to text as it still
maintains this character somewhere.

Please can someone please tell me how to formute the cell as 123 Street Unit
4?



--

Dave Peterson