Ctrl + J to find and replace Alt + Enter in multi line cell contents or Text to Columns
alansidman gave an answer to use Ctrl + J in Text to Columns to separate multiple lines of text contained in a single cell caused by using Alt + Enter http://www.excelforum.com/excel-gene...ml#post3568288
I did a search on Ctrl + J (because I had never heard of it) and found this bit to go along with it by Dave Peterson - Microsoft MVP
Ctrl-j is the same as alt-enter. Another way to enter is Alt + 0010 on the numeric keypad.
Ctrl + J can be used in the Replace using * as a wildcard
*(Ctrl-j) should delete everything through the last alt-enter keeping text
after that last alt-enter.
(Ctrl-j)* should delete everything from the first alt-enter through the rest of
*(ctrl-j)* should clear all the cells that contain at least one alt-enter.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Rhudi in forum Excel Programming / VBA / Macros
Last Post: 09-30-2013, 05:19 PM
By AimeeNZ in forum Excel Programming / VBA / Macros
Last Post: 09-12-2012, 01:06 AM
By gettingthere in forum Excel Programming / VBA / Macros
Last Post: 01-27-2009, 03:24 PM
By richardeallen in forum Excel General
Last Post: 11-30-2006, 07:17 AM
By 1scant in forum Excel Programming / VBA / Macros
Last Post: 02-16-2006, 03:53 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1