Extract sentence that begins with 1.

[manoj18071965]

I have multiple cells around 200 having each cell text like below. I need only information starting with 1. up till 1. ends (Example: 1.A mounti... ...in disalignment. )

Following description includes:
1.A mounting system for supporting on a dental endosseous implant having a longitudinal implant axis is in disalignment.
2. A mounting system as device in claim 1, further comprising a fastener means for fastening the transmucosal member to the implant.
3. A mounting system as defined in claim 2 wherein the fastener means is a fixation bolt for screwing.
4. A mounting system as defined in claim 1 further comprising a fastener means for fastening the transmucosal member.
5. A mounting system as defined in claim 1, wherein the mounting system.

 

[markmzz]

Yes the provided information is in 1 cell and there are multiple cells having different information in same numbering format (1. 2. 3. and so on). In some cases cell information is starting with 1. and in some cases it is starting with text and then followed by 1. 2. .....

Hi Manoj18071965!

Did you try my suggestion of post #4? If yes, tell me the results.

Use Ctrl+Shift+Enter and not just Enter to enter the formula:

​

=IFERROR(MID(MID(A1,FIND("1.",A1),8^9),1,SMALL(IFERROR(FIND(ROW($1:$99)-1&".",MID(A1,FIND("1.",A1),8^9)),8^9),2)-1),"")​

Markmzz

 

[manoj18071965]

Thank you Bosco. Now it perfectly works.