查找和在Google Spreadsheet上用换行符替换逗号 [英] find & replace commas with newline on Google Spreadsheet

问题描述

我一直在尝试找出如何用换行符代替逗号.我尝试使用Unicode表示形式的(/r/n/)，char(10)(现在不记得了)，但是可以预见的是，用我在另一个框中键入的内容替换了逗号，而不是将其转换为换行符

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包含以下内容:"stack，overflow" 那么如果您在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=zh-CN&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 Spreadsheet现在支持使用\ n搜索换行符，方法如下: 编辑->查找和替换

UPDATE 2016-AUG Google Spreadsheet now support searching for newline using \n here is how: Edit -> Find and Replace

这篇关于查找和在Google Spreadsheet上用换行符替换逗号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！