Thread: star has to come
View Single Post
 
Old 02-24-2012, 12:54 AM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
  
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default star has to come





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
File Type: xlsx Book1.xlsx (11.0 KB, 8 views)
Reply With Quote