deleting new line character

A have a worksheet in excel which was copied from pdf.
in each cell number of different lines, the data appears on a new lines. the same as using the new line character. (ALT + ENTER)

The document is huge. well over 3000 individual cells, and generally 4 or 5 lines in each one. Is there anyway i can globally change the whole documents. Just deleteling all the new lines??

Using excel 2007 on windows xp..

unfortunately nothing is happening. when i press and hold alt.. and type in the numeric code.. nothing is happening. the box is just remaining empty. any idea why this might be?

When i try that.. the find/replace function isn't reading the character.

Maybe if i give an example of what i am trying to do it, there might be another way to do it..

For Example

My Name
is
John. I Live in a
house


This is way i have the data..

I want to be able to present it like

My names is john. I liive in a
house.

and let it go on to a new line when it reaches the end of the cell

when i try that. the alt+010.
its returns a message saying its excel can't find a match.
is it possible that excel is reading it as something different since it was copied in..

the data i am working on is all private.. and i'm i think if i start altering so that its ok to put but, i'll just be changing it to much..

was messing bout there.. and if i wish the TRIM function in the text fucntion. it will print it all on line. the problem still remains though. if i double click in the cell and then outside it again it resorts back to the original. however. before this. the lines appear as a (excuse the lack of techinal symbol) a box with a question mark in it.

if one types =char(10) this is symbol. all i want to do at this stage it replace this symbol with a space but sitll having the same problem

try to find what code it is by puting cursor at end of last word of first row and delete just the letters using back space , then use =code(a1) on mine it returns 10 but you may have a different one in there from where it was copied
so
martin
wilson
test
becomes
wilson
test

andy.. i am presuming that peice of code you show me.. represents the ascii codes for the individual characters.. showing the character up as 10. been the space.. wat i want to do it change this '10' to a '32' .. 32 been the spacebar character..

just coz your info is confidential doest mean you couldnt post an example of a few cells deleting everything except the last and first letters
martin
wilson

becomes

n
w

"3.0 Schedule
C submitted the work progress chart as of end of 2.
(Appendix)
P advised C that ng
the that
productivity areas.
According O, date
of 02.
This not
be progress
improves immediately.
C intend to
do time
resolves chedule."


is that any use??? just deleted txt in between.. but the start and ends sud be the same

i understand what ur saying with that code..

but never used VBE immediate window before..

can ya give me a quick run down with it??

OH MY GOD...
that does exactly what i want..

probably pushing the boat out a bit now..
but is there a way i can get that to work globably on the whole program??

A MILLION THANKS YOU..
thank you thank you.. i think you just saved me about 3 weeks work there...

just as a question , have you saved the workbook first? replace alt+010 only works if the data has been saved in a work book
you can't just open one stick in a load of data then use it.

ye.. all the data saved 1st.. so its ok that way..

You can use the CLEAN function, which removes all non-printable characters.

This worked well for me.