Formula to separate names

[Prasad K]

i have applied formula to separate first and middle and last within special characters in cell

here middle name not extracted full i have applied formula like this

Data Validation.xlsx
	A	B	C	D
14	Mohan/Prasad-Rao	Mohan	Pra	Rao
15	Vamsi/Prasad-Verma	Vamsi	Prasa	Verma
Sheet1

Cell Formulas
Range	Formula
B14:B15	B14	=LEFT(A14,FIND("/",A14)-1)
C14:C15	C14	=MID(A14,FIND("/",A14)+1,LEN(A14)-FIND("-",A14,FIND("/",A14)-1))
D14:D15	D14	=RIGHT(A14,LEN(A14)-FIND("-",A14,FIND("-",A14)-1))

 

[DHP]

Try this in C14=MID(A14,FIND("/",A14)+1,(FIND("-",A14)-FIND("/",A14))-1)

 

[Peter_SSs]

A couple of other possible options

22 06 14.xlsm
	A	B	C	D
14	Mohan/Prasad-Rao	Mohan	Prasad	Rao
15	Vamsi/Prasad-Verma	Vamsi	Prasad	Verma
Split Text

Cell Formulas
Range	Formula
B14:B15	B14	=LEFT(A14,FIND("/",A14)-1)
C14:C15	C14	=MID(A14,LEN(B14)+2,LEN(A14)-LEN(B14&D14)-2)
D14:D15	D14	=REPLACE(A14,1,FIND("-",A14),"")

 

[Prasad K]

Try this in C14=MID(A14,FIND("/",A14)+1,(FIND("-",A14)-FIND("/",A14))-1)

Thank you so much @DHP

 

[Prasad K]

A couple of other possible options

22 06 14.xlsm
	A	B	C	D
14	Mohan/Prasad-Rao	Mohan	Prasad	Rao
15	Vamsi/Prasad-Verma	Vamsi	Prasad	Verma
Split Text

Cell Formulas
Range	Formula
B14:B15	B14	=LEFT(A14,FIND("/",A14)-1)
C14:C15	C14	=MID(A14,LEN(B14)+2,LEN(A14)-LEN(B14&D14)-2)
D14:D15	D14	=REPLACE(A14,1,FIND("-",A14),"")

Thank you so much @Peter Sir

 

[Peter_SSs]

You're welcome.