Separate/delimited cells based on numeric characters

[mlarson]

Hi all, hope you guys and gals are doing well! Question for you that I'm hoping you can help me with. Thanks in advance for anybody that tries to help.

I would like all cells separated/delimited whenever one of the following two instances occur, and I'd like those numeric characters included (so delimited/separator should be before the number occurs, I think):
" #.#)" or "#. " (where # means an actual number).
So, some examples:
" 1.2)"
" 3.7)"
" 4.1)"
"1. "
"6. "
"7. "

I have things like the following all in one cell...
Questions: 1. Why did the cat run up the tree? 2. Is the sky blue? 3. Is the planet Mars made out of the same stuff as the candy bar by the same name?
(not real question, of course, just giving examples)

The output would be (and I don't care the output cell locations/addresses, they can be anywhere).
In a cell: 1. Why did the cat run up the tree?
In a different cell: 2. Is the sky blue?
In yet another different cell: 3. Is the planet Mars made out of the same stuff as the candy bar by the same name?

Same idea with " 1.2)", " 3.7)", " 4.1)", etc.

Thank you! And please let me know if I need to include more info. Hopefully I explained this clearly.

 

[JvdV]

Excel 2010? Hm, I think all these functions should be available:

Book1
	A	B	C	D
1	Questions: 1. Why did the cat run up the tree? 2. Is the sky blue? 3. Is the planet Mars made out of the same stuff as the candy bar by the same name?	1. Why did the cat run up the tree?	2. Is the sky blue?	3. Is the planet Mars made out of the same stuff as the candy bar by the same name?
Sheet5

Cell Formulas
Range	Formula
B1:D1	B1	=MID($A1,SMALL(IF({1,0},IFERROR(FIND(ROW($1:$99)&". ",$A1&"4. "),""),IFERROR(FIND("."&ROW($1:$99)&")",$A1&"4. "),"")),COLUMN(A1)),SMALL(IF({1,0},IFERROR(FIND(ROW($1:$99)&". ",$A1&"4. "),""),IFERROR(FIND("."&ROW($1:$99)&")",$A1&"4. "),"")),COLUMN(B1))-SMALL(IF({1,0},IFERROR(FIND(ROW($1:$99)&". ",$A1&"4. "),""),IFERROR(FIND("."&ROW($1:$99)&")",$A1&"4. "),"")),COLUMN(A1)))
Press CTRL+SHIFT+ENTER to enter array formulas.

I dragged the formula right.

 

[mlarson]

That seemed to work, thank you! I'll let you know if I run into any problems.

Yeah, 2010. I should probably update that at some point