在单元格(CSV)中添加换行符 [英] Adding a newline character within a cell (CSV)

问题描述

我想导入需要根据描述，尺寸，表面处理等内容在逻辑上中断的产品描述.如何插入换行符，以便在导入文件时它们会显示出来?

I would like to import product descriptions that need to be logically broken according by things like description, dimensions, finishes etc. How can I insert a line break so that when I import the file they will show up?

推荐答案

在还应考虑在Excel中对多行进行反向工程.要将换行符嵌入到Excel单元格中，请按Alt + Enter.然后将文件另存为.csv.您会看到双引号从一行开始，并且文件中的每个新行都被视为单元格中的嵌入式换行符.

Consider also reverse engineering multiple lines in Excel. To embed a newline in an Excel cell, press Alt+Enter. Then save the file as a .csv. You'll see that the double-quotes start on one line and each new line in the file is considered an embedded newline in the cell.

这篇关于在单元格(CSV)中添加换行符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！