please i need in c3 function until c6 a function that

[mgm90210M]

a	b	c	d	e	f	g
2						id
3	ronld com co if	ronld				co
4	com dan	dan				com
5	guy id mano roi	mano				roi
6	roni soares fri mito	soares fri mito				guy
7						roni

<tbody>
</tbody>

please i need in c3 function until c6 a function that
will in
c1 take the sentence in b3 and remove the word that in g colom ( g2 antil g7)

the word will remove please
and will include space instant of the word that remove

like in b6 remove only "roni" that include in g column


thanks

 

[Momentman]

For B3, why do you keep only ronld? because "co" and "if" are not in g3:g6, am i missing something?

 

[mgm90210M]

For B3, why do you keep only ronld? because "co" and "if" are not in g3:g6, am i missing something?

you right

 

[mgm90210M]

anybody can help me ?


it is imported to Pay attention that when in g column have the word "com"

the function only delete "com"
and not "commmg"