Help formular!!!

[Nguyen Anh Dung]

i have cell A1: Vợ chồng ông Thiều Linh Vủ và bà Hồ Thị Mỹ Châu.
I want result cell B1:ông Thiều Linh Vủ
cell C1: bà Hồ Thị Mỹ Châu
As shown below

best regards,
Nguyen Anh Dung

 

[6StringJazzer]

The example is nice but you have to explain what your algorithm is to get the results in B1 and C1. The example by itself does not explain how to do it.

 

[Nguyen Anh Dung]

T

The example is nice but you have to explain what your algorithm is to get the results in B1 and C1. The example by itself does not explain how to do it.

Thanks you. i have use formular result ok!!!
TRIM(SUBSTITUTE(TRIM(LEFT(SUBSTITUTE(F7,"và",REPT(" ",100)),100)),"Vợ chồng",""))
TRIM(RIGHT(SUBSTITUTE(F7,"và",REPT(" ",100)),100))

Thanks!!!
Dung