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!
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!
Last edited by yawnzzzz; 01-19-2010 at 05:12 PM.
Perhaps like this?
=SUBSTITUTE(A1,CHAR(10)," ")
Try running this macro on selected cells.
You can chose choose a different ReplaceCharacter if you wish.Please Login or Register to view this content.
Martin
Perfect. Thanks!
I just switched it up to make it a function:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks