基本操作 → 数据透视表 → 函数 + 图表 → (SQL) → ① VBA/② (PQ+PP→PBI)
=LEFT('今晚一起看电影?',2)→ 今晚=RIGHT('太阳从西边出来了,我就去',3)→ 我就去= MID('在金星上太阳就是西升东落的,那我先带你去金星',9,4)→ 西升东落
= LEN('你叫什么名字?')→ 7
=FIND('THE new','This is THE new way')→ 9=SEARCH('the new','This is THE new way')→ 9
=TRIM(' This is the new way ') → This is the new way
= SUBSTITUTE('This is the new way','new','old')→ This is the old way= REPLACE('This is the new way',13,3,'old')→ This is the old way
=TEXT(0.0469,'0.0%')→ 4.7% =TEXT(TODAY(),'yyyy年mm月dd日|aaaa') → 2019年08月18日|星期日
联系客服