How to capter enter key from excel cell

[sarsukanth]

Hi,

I want to capter enter key and know in which possition it is there, from one excel cell, is it possible, if yes please tell me the excel formula.
thank U for your support.

Best Regards,
Raghukanth

 

[Ruddles]

An Excel cell can't contain an 'Enter key': when you press Enter, it doesn't get added to the contents of the cell, it merely confirms the entry of the data into the cell.

Do you mean a linefeed character? Do you have a cell with multiple lines in it, separated by linefeeds?

If not, what exactly are you trying to do?

 

[sarsukanth]

Hi Ruddles,

exactly...! now i want to capture that linefeed.
is it possible? if yes please give the formula.
and is there any formula that will give the ascii value of given character in the excel?
please reply my queries, thankU for your support.


Raghukanth

 

[Ruddles]

Linefeed is CHAR(10) so if you want to find a linefeed in cell A1, you would use this formula:-

=FIND(CHAR(10),A1)

The bit before the linefeed would therefore be:-

=LEFT(A1,FIND(CHAR(10),A1)-1)

And the bit after it would be:-

=MID(A1,FIND(CHAR(10),A1)+1,255)