If you copy and paste from another application into Excel, chances are you’ll come across some boxes that create unsightly line breaks in your cells.
Use this formula to make those line breaks disappear:
=SUBSTITUTE(SUBSTITUTE([celladdress],CHAR(13)," "),CHAR(10),"")
where [celladdress] is the cell you are fixing
Warning: you will have the Who song Substitute stuck in your head after using this formula.
Nice dispatch and this post helped me alot in my college assignement. Say thank you you as your information.