Split Text using numbers as Delimiter.

Hi all,

I am new here, and i need help.

i have text with numbering in one cell. how i can split text using numbers as Delimiter.

for example:
(one cell)
1. How are you 2. I am fine 3. I am Great

result:

(3 cells)
1. How are you
2. I am fine
3. I am Great

Thanx in advance

yes i need the serial number.

i tried it using dot as a delimiter but it leads to number at the end of the cell, also some text includes dot.

Thanx DILIPandey

Thanx tom1977, i was really helpful.. is there is a way to make work on any cell, not only a1 ?

Please find sample worksheet attached. if possible insert new raw with any additional cell of "controls" (second column).