Excel extracts a paragraph of text?

After reading your data source, in this case, I suggest not to use function extraction and separate the data directly.

Specific operation:

1, select column B.

2. Click Data → Subdivision.

3. Select the delimiter, and then click Next.

4. Tick "Other", enter/in the following text box, and click "Finish".