Issues with pasting values in to Excel

[Mancunian]

I have some analysis which I am carrying out in Alteryx where I am querying an Access database. For the field Project Name. all appears fine when I view the output in Alteryx. However, when I paste the field data in to Excel, the rows split their value i.e the values appear in to different rows in excel. Is there anyway around this?

For Example the text appears like this in Access  

"Horse and Jockey PH
66 Church Lane
Buckley
Clwyd"

and hence is on separate lines when I paste it in to Excel. What changes can I make in Alteryx to prevent this from happening?

[jrgo]

@Mancunian,

I don't think it's an issue with Alteryx, rather how Excel is interpreting data pasted from your clipboard.

If you just paste into an Excel cell by selecting the cell (single click) then Excel thinks that each new line should be a new row. Otherwise, you can double-click the cell and then paste, or paste it directly in the Formula bar to prevent it from splitting.

Also, if you use an output tool, it would output into one cell.

[NickR82]

I have a different copy paste into Xcel issue. It is treating a 0 in the middle of numbers or mixed text as a delimiter and opening a new column,  

1

1

HIPBK

example of what gets pasted 

vs what should be 

101 HIPBK  

I have formatted as text can't think of why or what it is doing it was a V String, I changed to VW String? 

Other Example 

344

7P

86

-1

7

344007P 860-107

Any help would be appreciated Thanks..