I suspect you have been successful in inserting an ASCII 10 character but you do not have 'Wrap text" enabled for the cell so the display does not show multiple rows. The array formula
= CODE( MID( ref, {1,2,3,4}, 1 ) )
will test a four character string to see whether a 10 is present.