TEXT

http://www.appspro.com/

=zeichen(13)  - Zeil Umbruch

=commas    =text(cell with commas;"??/??")

When you are looking for a number in a string of data.

=TEIL(I3;MIN(WENN(ISTZAHL(--TEIL(I3;SPALTE(3:3);1));SPALTE(3:3)));8)

3 is when you start in row 3, 8 is the expected number of numbers