Excel for Mac

RealEyes

macrumors regular
Original poster
Jun 23, 2012
184
0
WTH!?! Why can't I paste values?

I'm copying data from a webpage that contains links, colors, columns separated by gaps and when I go into Excel to paste ONLY the values, it wont let me. When I try to paste special - plain text, instead of keeping the formatting of rows and columns, it puts it all into one column with the data on different rows.

This does me no good. Whats the problem here?
 

Attachments

MisterMe

macrumors G4
Jul 17, 2002
10,650
28
USA
I never use the command, but Excel has a command that will split a column like yours into multiple columns--one for each value.
 

GGJstudios

macrumors Westmere
May 16, 2008
44,419
759
WTH!?! Why can't I paste values?

I'm copying data from a webpage that contains links, colors, columns separated by gaps and when I go into Excel to paste ONLY the values, it wont let me. When I try to paste special - plain text, instead of keeping the formatting of rows and columns, it puts it all into one column with the data on different rows.

This does me no good. Whats the problem here?
What site is it? How you paste and how it appears in Excel will vary, depending on the format of the page you're copying. I'll test it if you can provide a link. (if it's not private or proprietary)
I never use the command, but Excel has a command that will split a column like yours into multiple columns--one for each value.
You may be thinking of the Text to Columns function, but it may not help if the web page isn't formatted properly for Excel.
 

RealEyes

macrumors regular
Original poster
Jun 23, 2012
184
0
What site is it? How you paste and how it appears in Excel will vary, depending on the format of the page you're copying. I'll test it if you can provide a link. (if it's not private or proprietary)

You may be thinking of the Text to Columns function, but it may not help if the web page isn't formatted properly for Excel.
It is private. It seems to work a little better when using chrome but, it just sucks that Excel is completely different on Win7.
 

MisterMe

macrumors G4
Jul 17, 2002
10,650
28
USA
Chrome and Safari are both WebKit browsers. As for Excel, my experience with Text to Columns is that it works the same on the Mac as on Windows.