Removing Returns

Hi,

I have some cells full of user entered information that has returns in it, so that it's multiple lines long. What's the best way to remove returns from a string?

Thanks!

Try running this macro on selected cells.

Please Login or Register  to view this content.

You can chose choose a different ReplaceCharacter if you wish.