i want formula to * in b1 related with spaces in c1
i inserted column between two rows ie., c1 become d1

i keep formula
=if(and(b1="*",len(d1)>1,"*","")

my question is how to make "*" stable until the length d1 is one
find the attachment

Attached Files

Book1.xlsx (11.0 KB, 8 views)