excel常用函数

转为mac地址格式

=replace(replace(substitute(a1,"-",),5,,"."),10,,".")

目标单元格内容替换为小写

=lower(a1)

替换为全大写

=upper(a1)

首字母替换为大写

=proper(a1)