Evertything seems to paste only in column A

[choli0090]

I was hoping someone can help me. It seems that lately every time, I copy from a source (such as SQL Server), to Excel it puts everything in to column A, instead of separating everything into the multiple columns like how SQL is showing the data.

Before this worked, but it just seems like recently it stopped working.

Does anybody know a workaround? I could try using Text to columns, but the problem is when I pasted the data, there isn't any commas, spaces, etc

Excel - O365 Ver 1902

Thanks

 

[Michael M]

What does seperate the data ??
Can you post a small sample of the SQL data ??
Are you using a macro to import the data ?

 

[choli0090]

I can't post an exact sample of what I'm looking at (at work), but below is an example. The top row is an example of the source data (Separate by columns). When I paste the paste the header column will end up showing like the 3rd row.
This is a copy/paste I've never had any issues before, especially when the source data is in the top line format below.



[TABLE="width: 500"]
<tbody>[TR]
[TD]Header1[/TD]
[TD]Header2[/TD]
[TD]Header3[/TD]
[TD]Header4[/TD]
[TD]Header5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Header1Header2Header3Header4Header5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]