Formula to separate text from number

[zeldy]

what is the formula to sepate number and text to two rows
see file

 

[vletm]

zeldy
to two columns ...
to cell C7 =LEFT(A2,5)
to cell D7 =MID(A2,7,255)
and copy both down

 

[pecoflyer]

Alternatively
Data - Text to columns - Check Fixec width - Next - Place break lines where required - Next - Change data format if required - Finish

 

[Peter Bartholomew]

Separating on the first space

= HSTACK(
    TEXTBEFORE(data, " "),
    TEXTAFTER(data, " ")
  )

or dressing it up to allow for lines without any number

= LET(
      firstString, TEXTBEFORE(data," "),
      remainder,   TEXTAFTER(data, " "),
      left,        IF(ISNUMBER(--firstString), firstString, ""),
      right,       IF(ISNUMBER(--firstString), remainder, data),
      HSTACK(left, right)
  )