Link to home
Create AccountLog in
Avatar of finnstone
finnstone

asked on

Extract sentences after two periods

extract first two sentences from values in excel cells in column A

Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Can you attach a sample workbook?
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account

You may even enter it as a dynamic array formula in a single cell:

=IFERROR(TEXTBEFORE(A2:A5,".",2) & ".",A2:A5 & "")

Open in new window


If you are using an older version of Excel, you may use:

=IFERROR(LEFT(A2,FIND("|",SUBSTITUTE(A2,".","|",2))), A2 & "")

Open in new window