excel 操作技巧

随机筛选数据                 =INDIRECT("B"&RANDBETWEEN(1,56565))

替换前面指定位数          =SUBSTITUTE(A1,LEFT(A1,4),&quo