When copying data from Forum threads, data is pasted into only one column

[mumps]

The title really says it all. If I copy data from a posted table or any form of posted data and paste it into an Excel worksheet, each column of data is pasted into one column, one underneath the other, instead of into rows and columns. Any help would be appreciated.

 

[JLGWhiz]

Pasting options on this forum are certainly limited, except for the highly skilled users. Almost everything, especially text, is in a single box.

Go to this thread and see if you can copy to a sheet with data in different cells.

https://www.mrexcel.com/forum/excel...itting-data-into-months-based-date-range.html

I was able to get the data to paste in separate cells on my system.

 

[mumps]

It's frustrating if I'm trying to help another forum member. I copy the data from the post into Excel so that I can test a possible solution but it's pasted into one column. I would have to manually input all the data into the corresponding rows and columns in order to work with it. I don't know exactly when this problem started (not too long ago) but I do know that I used to be able to copy posted data from the forum and paste it into an Excel sheet without any problems. I'm wondering if there are any settings that might affect copy/paste.

 

[sandy666]

out of curiosity: from which post you want to copy the table?

 

[JLGWhiz]

The system would have to be set to remove all non printing characters (or similar) to cause that result, I would think. Have you checket your system settings lately to see how your paste parameters are set?

 

[mumps]

@sandy666
I have tried with many posts but here is the link to one: https://www.mrexcel.com/forum/excel...eck-each-row-criteria-delete-row-2-below.html
I copy the posted data and when I paste it in A1 of a worksheet, it goes down the column.

@JLGWhiz
I looked at all the settings in Excel...Options but I couldn't find anything that applied. I'm not sure what you mean by "system settings".

 

[JLGWhiz]

@sandy666
I have tried with many posts but here is the link to one: https://www.mrexcel.com/forum/excel...eck-each-row-criteria-delete-row-2-below.html
I copy the posted data and when I paste it in A1 of a worksheet, it goes down the column.

@JLGWhiz
I looked at all the settings in Excel...Options but I couldn't find anything that applied. I'm not sure what you mean by "system settings".

You have some settings for Internet Options>Advanced that might affect how your data is managed for copy/paste. example using codecs for HTML. But I am not a tech so I don't know exactly which ones might cause such a problem. It does sound like a setting problem more that a bug.

 

[sandy666]

hm, I can't reproduce your problem

 

[sandy666]

maybe try this way:

imagine the table in the post has blank rows/columns around (yellow) and start selection from point A to point B not from start point of data

 

[mumps]

@JLGWhiz
Unfortunately, I couldn't find anything applicable.
@sandy666
This is what I get:4
Excel 2010 32 bit
[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]SKU[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Type[/td][/tr]

[tr=bgcolor:#FFFFFF][td]KW1[/td][/tr]

[tr=bgcolor:#FFFFFF][td]KW2[/td][/tr]

[tr=bgcolor:#FFFFFF][td]KW3[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SUM[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU1[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Actual Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

30​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

41​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

28​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

99​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU1[/td][/tr]

[tr=bgcolor:#FFFFFF][td]LY Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

46​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

41​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

25​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

113​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU1[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Forecst[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

40​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

42​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

43​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

125​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU2[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Actual Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1084​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

793​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

2022​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

3899​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU2[/td][/tr]

[tr=bgcolor:#FFFFFF][td]LY Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

950​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

958​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

765​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

2672​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU2[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Forecst[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

871​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

790​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1659​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

3320​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU3[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Actual Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

44​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

24​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

54​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

123​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU3[/td][/tr]

[tr=bgcolor:#FFFFFF][td]LY Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

3​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

46​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

40​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

150​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU3[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Forecst[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

44​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

41​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

40​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

125​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU4[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Actual Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

655​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

379​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

284​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1318​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU4[/td][/tr]

[tr=bgcolor:#FFFFFF][td]LY Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

343​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

257​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

329​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

929​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU4[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Forecst[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

641​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

265​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

342​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1247​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU5[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Actual Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU5[/td][/tr]

[tr=bgcolor:#FFFFFF][td]LY Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1042​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1042​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU5[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Forecst[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

5​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

5​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU6[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Actual Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU6[/td][/tr]

[tr=bgcolor:#FFFFFF][td]LY Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

60​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

47​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

58​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

164​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU6[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Forecst[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU7[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Actual Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU7[/td][/tr]

[tr=bgcolor:#FFFFFF][td]LY Sales[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

66​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

71​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

47​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

184​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SKU7[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Forecst[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]
I tried it with Excel 2010 and Excel 2013 ad got the same result. I'm thinking it must be a setting outside of Excel but I can't figure out what that is.