查找 &用 Google 电子表格上的换行符替换逗号 [英] find & replace commas with newline on Google Spreadsheet
问题描述
我一直在想办法用换行符替换逗号.我试过使用 (/r/n/)
, char(10)
,Unicode 表示(现在不记得了),但它相当可预见地替换了逗号使用我在另一个框中输入的任何内容,而不是将其转换为换行符
I've been trying to figure out how to replace commas with line-breaks. I've tried using (/r/n/)
, char(10)
, the Unicode representation (can't remember now), but it rather predictably replaces the comma with whatever I type in the other box, not converting it to a line-break
推荐答案
如果您尝试使用 Ctrl+F 来查找和替换,则您不能.至少我不知道怎么做.
IF you are trying to use the Ctrl+F to find and replace well you can't. at least I dont know how.
但是如果您有一个单元格,请说 A1 包含以下内容:堆栈,溢出"那么如果你在 A2 中输入它应该可以工作:=SUBSTITUTE(A1, ",", char(10))
but if you have a cell say A1 that contains the following : "stack,overflow" then if you type this in A2 it should work: =SUBSTITUTE(A1, ",", char(10))
https://support.google.com/docs/bin/static.py?hl=en&topic=25273&page=table.cs
然后您可以复制 A2 的内容并在 A3 中右键单击 -> 选择性粘贴... -> 仅值.
you can then copy the content of A2 and in A3 right click -> Paste Special... -> Values Only.
希望能帮到你
更新 2016-8 月Google 电子表格现在支持使用 搜索换行符,方法如下:编辑 -> 查找和替换
UPDATE 2016-AUG Google Spreadsheet now support searching for newline using here is how: Edit -> Find and Replace
这篇关于查找 &用 Google 电子表格上的换行符替换逗号的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!