向高手请教一个在EXCEL中字符串转换问题如何将nt_memb_name转换成ntMembName?也就是将_去掉但是后面的字符要转换为大写的。[解决办法]假设你的数据在A1 =LOWER(LEFT(SUBSTITUTE(PROPER(A1), "_ ", " "),1))&RIGHT(SUBSTITUTE(PROPER(A1), "_ ", " "),LEN(SUBSTITUTE(PROPER(A1), "_ ", " "))-1)
