Page 1 of 1
replace texts
Posted: Thu Mar 11, 2021 10:17 am
by sna
Hi Dear!
I need your help to replace texts within the range.
I also place the expected results in adjacent column.
Attached file
Thank
Re: replace texts
Posted: Thu Mar 11, 2021 11:04 am
by norkaz
B2
=SUBSTITUTE(A2,LOOKUP(99,SEARCH($D$2:$D$6,A2),$D$2:$D$6),LOOKUP(99,SEARCH($D$2:$D$6,A2),$E$2:$E$6))
Norkaz
Re: replace texts
Posted: Fri Mar 19, 2021 5:09 pm
by sna
Thanks.I want to ask is it possible to do formula Substitute with index ?
Re: replace texts
Posted: Fri Mar 19, 2021 11:36 pm
by norkaz
B2
=SUBSTITUTE(A2,INDEX($D$1:$D$6,AGGREGATE(14,6,ROW($D$2:$D$6)/ISNUMBER(SEARCH($D$2:$D$6,A2)),1)),INDEX($E$1:$E$6,AGGREGATE(14,6,ROW($D$2:$D$6)/ISNUMBER(SEARCH($D$2:$D$6,A2)),1)))
Norkaz
Re: replace texts
Posted: Sat Mar 20, 2021 6:26 am
by sna
Thanks