Replying to a post made in May 2010.

December 8, 2015 at 06:33:56
Specs: Windows 7
I experienced this same issue when I upgraded from Excel 2007 to Excel 2010. When I copy from outside of Excel and try to paste in Excel, it concatenates everything into the first column. Using the text-to-columns option does not delimit correctly. The only thing that has worked for me was the suggestion made by "mmcconaghy" above. First paste into Word, then select all and copy, then paste into Excel. It's an extra step, but it does the job. Wish there was a setting I could just change to resolve this though.

See More: Replying to a post made in May 2010.

Report •

December 8, 2015 at 07:23:50
Your post mentions "A Post Made In May 2010" and "the suggestion made by "mmcconaghy" above" yet there are no links to the 2010 post or to mmcconaghy's suggestion.

Was there a specific reason you brought this issue up again?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Report •

December 8, 2015 at 07:27:28
Yes, I was looking for a solution to this issue when I came across a post made in May 2010 to this message board. When I tried to reply, it made me create a new post. The original post didn't acknowledge whether mmcconaghy's suggestion worked or not. Despite my other web searches, I found it to be the only solution that works.

Report •

December 8, 2015 at 11:28:45
Post the link to the May 2010 thread please by coping and pasting the thread URL.

i_Xp/Vista/W7/W10 User

Report •

Related Solutions

December 8, 2015 at 15:17:12
Checked my old threads and this seems to be the one the OP is talking about:

Not completely sure.


message edited by mmcconaghy

Report •

Ask Question