You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語Text » Remove ending carriage return (Alt+Enter)
This utility removes the carriage returns (Alt+Enter character) that are at the end of in each cell in your selection.If you want to remove or replace all carriage returns/linefeeds, you can use the "Advanced character remove or replace..." utility.
Screenshots
Starting this utility
In the Excel menu choose: ASAP Utilities » Text » Remove ending carriage return (Alt+Enter)« Return to the list of “Text” tools.
| « Previous Delete all numbers in selection | Next » Delete number of leading characters... |
You can do this too
Download "The one essential add-in for all Excel users."
Additional keywords for this tool:
find carriage returns, line feeds
find carriage returns, line feeds
© 1999-2021 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
