Thread: Split a text
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Split a text

CTRL + j also works in the "replace what" dialog to locate the linefeed Alt +
Enter


Gord Dibben MS Excel MVP

On Wed, 17 Oct 2007 13:10:23 +0100, "Roger Govier"
<rogerattechnology4NOSPAMu.co.uk wrote:

Excellent Ron!

I had tried typing Alt Enter, and Char(10) into the box - all to no avail.
Didn't think about using your method.