Page 1 of 1
add asterisk
Posted: Mon Nov 15, 2021 9:57 am
by sna
Hi Dear,
Hope you all doing well.
I need an answer how to write formula to add * after repeated letter as in attached file
Thanks
Re: add asterisk
Posted: Mon Nov 15, 2021 12:02 pm
by norkaz
..
B2
=LEFT(A2)&CONCAT(IF(MID(A2,ROW(INDIRECT("1:"&LEN(A2)-1)),1)=MID(A2,ROW(INDIRECT("2:"&LEN(A2))),1),"*",MID(A2,ROW(INDIRECT("2:"&LEN(A2))),1)))
Norkaz
Re: add asterisk
Posted: Mon Nov 15, 2021 1:24 pm
by sna
sorry I use office 2016 no Textjoin or Concat
Re: add asterisk
Posted: Mon Nov 15, 2021 1:51 pm
by norkaz
..
D2:Lxx
=IF(MID($A2,COLUMNS($D2:D2),1)=C2,"*",MID($A2,COLUMNS($D2:D2),1))
B2
=LEFT(D2&E2&F2&G2&H2&I2&J2&K2&L2,LEN(A2))
Norkaz
Re: add asterisk
Posted: Mon Nov 15, 2021 6:57 pm
by sna
Thank you so much