我想在Google表格上的公式后自动添加文本 [英] I want to Auto-Add text after a formula on Google Sheets
本文介绍了我想在Google表格上的公式后自动添加文本的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我找到了一个从名称"单元格获取姓氏的公式,但是我想在姓氏后添加特定文本以将其设置为密码并将其自动应用于所有单元格,例如:
表格网址:
I found a formula to get the last name from a Name cell, but I want to add a specific text after the last name to make it a password and apply it automatically to the all cells, example:
Sheet URL:
https://docs.google.com/spreadsheets/d/1XHoxD-hNmpUOMVm_u-cz-4ESrabodsrS0fIfaN-n4js/edit
解决方案
Google-Sheet has REGEXTRACT()
function while excel desktop version don't have. You can use below function which will work both in google-sheet
as well as in excel all version.
=TRIM(RIGHT(SUBSTITUTE(C2:C," ",REPT(" ",100)),100))& "@2021"
For excel use-
=TRIM(RIGHT(SUBSTITUTE(C2," ",REPT(" ",100)),100))& "@2021"
这篇关于我想在Google表格上的公式后自动添加文本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文