split colum from text

[neenuadril]

I have a column like this below*showing two results ).I need to extract the text before the date .How can I do that?
Could you please suggest me a solution?

 

[AlanSidman]

Cannot manipulate data in a picture. Please upload a sample file of your raw data and then show us for that data a mocked up solution.

 

[bosco_yip]

I have a column like this below*showing two results ).I need to extract the text before the date .How can I do that? View attachment 84680
Could you please suggest me a solution?

Just guessing, suggest you to extract the text after a blank row.

If not the case, post a sample file with data as per AlanSidman mentioned in Level #2

 

[Peter Bartholomew]

It all depends on the Excel version; 365 solutions and traditional Excel have very little in common.
Assuming your data shows 2 data cells with line-feeds to display the lines, you might have something of the form

= LAMBDA(cell,
    LET(
      date, DROP(ISNUMBER(DATEVALUE(TEXTSPLIT(cell, " ", CHAR(10)))), -1, -1),
      text, DROP(TEXTSPLIT(cell,,CHAR(10)), 1),
      FILTER(text, date)
    )
  )(@data)

That is then changed to a named Lambda function and used within MAP.

= MAP(data, ExtractTopicλ)