remove char(10)

[Gaurav Karira]

Hi VBA geeks,

I have file where in there are many cells with Alt + Enter in them ie char(10) now the number of such cells is so large that i cant manually remove them with " " ie a blank space.

Please VBA geeks come to my rescue.....can some advise some code which traces all such cells and then replaces char(10) with " "

Cheers
Gaurav

 

[WillR]

see my reply to your post in the main Excel forum.