Paste issue with Excel 2008

[vls]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have used Office 2007 (on my PC) & iNumbers (on my iMac) to do the following - copy large amount of data and paste them into Excel with no problem. The data paste into columns so I can used the information as a worksheet. These are daily credit card transactions data I get from a secured website.

When I do the same operation for Excel 2008 all the data paste in a single column. What am I not doing correctly.

Thanks in advance for your help.

 

[CyberTaz]

Have you tried using Edit> Paste Special> Text rather than just dumping in
the copied HTML? You can use the Paste Options button that appears to select
the Text Import Wizard & specify the appropriate column separator.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[vls]

I have tried that as well, it paste everything in a single column instead of across the sheet?? Yet it works correctly on iNumbers & PC based Excel 2007.....

 

[alanl3]

I have tried that as well, it paste everything in a single column instead of across the sheet?? Yet it works correctly on iNumbers & PC based Excel 2007.....

It didn't work for me. I guess I don't know how to work with headers.
Any other suggestions?

Alan

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I have used Office 2007 (on my PC) & iNumbers (on my iMac) to do the following
- copy large amount of data and paste them into Excel with no problem. The
data paste into columns so I can used the information as a worksheet. These
are daily credit card transactions data I get from a secured website.

When I do the same operation for Excel 2008 all the data paste in a single
column. What am I not doing correctly.

Thanks in advance for your help.

Once the data is pasted and appears in a single column. Have you tried
Data-Text to columns? Does this work after the paste?

 

[vls]

I am new here to the Mac Excel, what is dat-text to columns?

 

[Bob Greenblatt]

I am new here to the Mac Excel, what is dat-text to columns?

Look in the Data menu. There is a text to columns option. It will parse data
into separate based on your specified delimiter. The function is the same in
Windows Excel.