Hi,

Just not to keep this in the box - Hector Migel Orozco Dias, an Excel MVP,
who, I believe, mainly contributes in the Spanish NG has proposed an
enhancement to the formula which is greatly appreciated:

1) define a name [e.g. CRLF] with the formula =CHAR(10)
2) in the main formula substitute all ocurrences of the funcion CHAR by the
defined name
3) now you can nest another IF...:

=IF(A1="","",IF(OR((LARGE((MID(A1&CRLF,ROW(INDIREC T("1:"&LEN(A1)+1)),1)=CRLF)*ROW(INDIRECT("1:"&LEN( A1)+1)),ROW(INDIRECT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1,CRLF,""))+1)))-LARGE((MID(A1&CRLF,ROW(INDIRECT("1:"&LEN(A1)+1)),1 )=CRLF)*ROW(INDIRECT("1:"&LEN(A1)+1)),1+ROW(INDIRE CT("1:"&LEN(A1)-LEN(SUBSTITUTE(A1,CRLF,""))+1))))255),"PLEASE
GO BACK TO "&CELL("address",A1)&" and PUT IN AN ALT ENTER",""))

Regards,
KL


"Mikeice" wrote in
message ...

Stupid me!
I was using the tick and tehn alt enter

Thanks so much guys!


You all really ROCK!!!

thanks :) :)


--
Mikeice
------------------------------------------------------------------------
Mikeice's Profile:
http://www.excelforum.com/member.php...o&userid=22467
View this thread: http://www.excelforum.com/showthread...hreadid=393600