excel formula to make a list of names with komma in between

[littlepete]

hello

following up on advice i got, this is a question about changing a list of names:

in one column i have for each person (row) the names of his children: for ex. : " mark. an. jules. pete. " that column is AV.
in the column after that AW is a number telling how much children there are.
the number of names is variable of course, depending on the parents !

how can i put a formula for that column F making a sentence saying : " he has 4 children : mark, an, jules and pete "

all have a great start of the advent !!!

 

[littlepete]

Should be

=AU2&" has "&AW2&" children: "&SUBSTITUEREN(SUBSTITUEREN(SUBSTITUEREN(AV2;".";",");",";".";AW2);",";" and";AW2-1)

hello all

i am very glad to announce that formula does work perfectly !!!
as i said before the case of no children or one child is already in my long formula, and now the x children is working too !!!

i am very happy to see this work !!! i'd like to thank all that participated in the quest for answers !!!
wishing you all a great first advent sunday !!!

 

[MARK858]

You're welcome, happy we helped but please mark post number 4 by @jasonb75 as the solution as it is his formula (I only translated it)