You have answers in your duplicated post.

Pete

On Jun 23, 5:08*pm, Ayo wrote:
Is the a way to perform a "Find and Replace All" action on all "ALT + Enter"
space in a worksheet witout having to manually go to each cell and delete the
space?