="INSERT into chars(chars.cr)VALUES ( "&A1&");"

=LEN(A1)

=UPPER(A1)

=LOWER(A1)

=PROPER(A1)

=IFERROR(INDEX(C:C,SMALL(IF(MATCH($C$2:$C$100,$C$2:$C$100,0)=ROW($C$2:$C$100)-1,ROW($C$2:$C$100)),ROW(C1))),"")

=MAX(Sheet开始名字:Sheet结束名字!C1)

=MIN(Sheet开始名字:Sheet结束名字!C1)

=CONCATENATE("INSERT INTO XXXX () VALUES"," ( N'SYSTEM', N'SYSTEM', GETDATE(), GETDATE(), N'SYSTEM', N'SYSTEM', "&D2&", N'"&B2&"', "&A2&", N'"&E2&"', N'"&C2&"');")