文本到列的功能不能正常工作?

I´ve this simple text inside a cell - this is an example of many with the same issue - and I need to put that into columns, delimited by spaces. When I do that, the function just do the work with the first sentence, finishing in "deck", and stops there so I´m loosing half of my information or more If I´ve more lines. I can´t understand why it´s happening, and I worked for hours on a macro that depends on this information as I wrongly assumed this would be plain easy.

我´ve这个简单的文本在一个细胞——这是一个许多相同的问题,我需要把成列,以空格分隔。当我这样做,这个函数只做第一句话的工作,完成“甲板”,并停止,所以我´失去一半或更多我的信息如果我´已经更行。我不能理解为什么它´s´发生,我工作几个小时一个宏,取决于这个信息我错误地以为这将是简单容易。

      ($94.52) Hold revenue. Need to set up deck.


      ($10.89) Hold revenue. Need to contact purchaser.

Thanks for your help!

谢谢你的帮助!

2 个解决方案

#1

Ok I got the answer so I´ll post it myself.

所以我得到了答案我自己´ll post。

I need to separate based on spaces and carriage returns, but I was just trying with spaces thinking there was no way to add carriage returns as a separator. I was wrong. When you select the function, you´ve a field called "other". There you need to add "Control + J", which is the shortcut for carriage returns. With that fix, the result is as expected.

我需要基于空格和回车进行分离，但我只是尝试使用空格，认为没有办法将回车添加为分隔符。我错了。当你选择函数,´字段名为“其他”。您需要添加“Control + J”，这是回车的快捷方式。通过这种修复，结果与预期一样。

#2

Assuming your column is A and starts in row 1, create a second column with the following formula in B1:

假设您的列是A，并从第一行开始，创建第二个列，其中的公式为B1:

=SUBSTITUTE(A1,CHAR(10)," ")

Copy down the entire B column. Copy and paste this column as values. Now use the Text to Columns functionality, but use space as the delimiter.

复制整个B列。将此列复制粘贴为值。现在使用文本到列的功能，但是使用空格作为分隔符。

#1