excel - Delete cell if it contains < 3 characters -
as title suggests, i'd delete cell (delete text) if number of characters in cells < 3.
for example
row1 row2 sn dwd
124 411 1 123
32 231 01 23
here, i'd "sn", "1", "32", "01" , "23" made blank cells.
assuming mean excel
sub clearcellswithlessthan3chars() dim cell range each cell in activesheet.usedrange if (len(cell.text) < 3) cell.clear end if next end sub 
Comments
Post a Comment