Extract text between characters

[zinah]

Hi,

I have below sample table that I'm trying to extract the text between the two hyphens in Chain 2, and text after the 2nd hyphen in Chain 3. Can anyone help with formulas?

Extract Text Formula.xlsx
	A	B	C	D	E	F	G	H
1						Exptected Results
2	Dimension value	Chain 01	Chain 02	Chain 03		Chain 01	Chain 02	Chain 03
3	John A	John A				John A
4	John A-Jame O	John A	Jame O			John A	Jame O
5	John A-Jame O-Maggie B	John A	Jame O-Maggie B	Maggie B		John A	Maggie B	Maggie B
6	John A-Jame O-Susan N	John A	Jame O-Susan N	Susan N		John A	Susan N	Susan N
7	John A-Jame O-Simon B	John A	Jame O-Simon B	Simon B		John A	Simon B	Simon B
8	John A-Jame O-James D	John A	Jame O-James D	James D		John A	James D	James D
9	John A-Jame O-Anne W	John A	Jame O-Anne W	Anne W		John A	Anne W	Anne W
10	John A-Jame O-Kevin M	John A	Jame O-Kevin M	Kevin M		John A	Kevin M	Kevin M
11	John A-John A-Mary O	John A	John A-Mary O	Mary O		John A	Mary O	Mary O
12	John A-John A-Olivia A	John A	John A-Olivia A	Olivia A		John A	Olivia A	Olivia A
13	John A-Perry O	John A	Perry O			John A	Perry O
14	John A-Perry O-Will B	John A	Perry O-Will B	Will B		John A	Perry O	Will B
15	John A-Teddy R	John A	Teddy R			John A	Teddy R
Sheet1

Cell Formulas
Range	Formula
B3:B15	B3	=IFNA(TEXTBEFORE(A3,"-"),A3)
C3:C15	C3	=IFNA(TEXTAFTER(A3,"-",1),"")
D3:D15	D3	=IFNA(TEXTAFTER(A3,"-",2),"")

 

[Rick Rothstein]

Delete whatever you have in cells B3, C3, D3 on down and try this formula in cell B3 copied down (it will fill across Columns B, C and D automatically)...

=TEXTSPLIT(A3,"-")

 

[zinah]

Delete whatever you have in cells B3, C3, D3 on down and try this formula in cell B3 copied down (it will fill across Columns B, C and D automatically)...

=TEXTSPLIT(A3,"-")

Thank you so much for this formula!, it worked perfectly great!