我想在 Google 表格上的公式后自动添加文本 [英] I want to Auto-Add text after a formula on Google Sheets

问题描述

我找到了一个公式来从 Name 单元格中获取姓氏，但我想在姓氏后面添加一个特定的文本以使其成为密码并将其自动应用于所有单元格，例如:

工作表网址:

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屋！