Text Before and After

[normpam]

Is it possible to split out text based on multiple occurrences of specific delimiters?
Make believe example:
"Integrity - we are good people, honest, fair.", Relationships - We build relationships.", Communication - We are an open book; and honest.", Constantly evolve - we always improve

This text is repeated in multiple cells, with each of the segments between the .", characters in different sequences.

Have tried to use TEXTBEFORE and TEXTAFTER, but have been unable to get a clean result. Hope this makes sense... Thanks!

 

[Anthony47]

Using the below test pattern, I used in B7 the formula

=TEXTSPLIT(B5,,"."",")

that splilled the 4 rows

If you prefer splilling to columns, use

=TEXTSPLIT(B5,"."",")

MULTI_C30717.xlsm
	A	B	C	D	E	F	G	H	I
4
5		"Integrity - we are good people, honest, fair.", Relationships - We build relationships.", Communication - We are an open book; and honest.", Constantly evolve - we always improve
6
7		"Integrity - we are good people, honest, fair
8		Relationships - We build relationships
9		Communication - We are an open book; and honest
10		Constantly evolve - we always improve
Foglio3

Cell Formulas
Range	Formula
B7:B10	B7	=TEXTSPLIT(B5,,"."",")
Dynamic array formulas.

 

[normpam]

Thanks. Now I need to study it a bit to make sure I understand!

 

[Rick Rothstein]

Using the below test pattern, I used in B7 the formula

=TEXTSPLIT(B5,,"."",")

that splilled the 4 rows

If you modify this formula like below, it will remove the leading quote mark (if any) and leading spaces (if any) on each outputted row...

=TRIM(SUBSTITUTE(TEXTSPLIT(B5,,"."","),"""",""))

 

[Anthony47]

Thanks. Now I need to study it a bit to make sure I understand!

Thank you for the feedback; the formula uses the function Textsplit, see TEXTSPLIT function - Microsoft Support