英文:
Spreadsheet] How do I remove whitespace after a specific character?
问题
| B |
|---|
| Good morning,Good afternoon,Good evening |
英文:
Overview
This function is used to translate Japanese into English.
| A | B |
|---|---|
| ja | en |
| こんにちは,こんにちは,こんばんは | =GOOGLETRANSLATE($A2,$B$1,A$1) |
B2 will output the following
| B |
|---|
| Good morining, Good afternoon, Good evening |
What I want to achieve
I would like to have the output with only the whitespace appearing after the comma removed as follows.
| B |
|---|
| Good morining,Good afternoon,Good evening |
I found some parts that did not work with all spaces gone or full-width characters, so if you could tell me how to do the above, that would be great.
答案1
得分: 1
如Tanaike上面所描述的，使用REGEXREPLACE()很容易实现。将其设置为将, 替换为, ，逗号后面的空格将消失。
英文:
As Tanaike described above, it is easy to do that with REGEXREPLACE(). Set it to replace , s with ,, and the spaces after commas will go away.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论