Issues with pasting values in to Excel

Question

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?

NickR82 · Answer

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,

11HIPBK

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 7P86-17

344007P 860-107

Any help would be appreciated Thanks..

jrgo · Answer

@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.