Problems copying from a table in an asp file to excel

fletch

Hi all

I've created a table in an asp file, however when you copy and paste the contents into excel, everything appears in one cell. I know I can paste into notepad and replace the spaces with tab spaces and it should display but I need this to work for dummies

<table>
<tr>
<td>Total</td><td>2500</td>
</tr>
</table>

Any suggestions?

pauldiv

where are you copying from?

brian_rbk

try this .. haven't got excel so couldn't try it myself ...

http://www.mrkent.com/tools/converter/

fletch

Thanks for the link brian but that doesn't work for me, all the data still gets dumped into one cell??

fletch

Found out how to do it easily
http://office.microsoft.com/en-us/excel/HA010450851033.aspx
"Within Internet Explorer

Internet Explorer (version 5.0 or higher) includes two ways for you to create a Web query in Excel from within Internet Explorer. These methods are described below.

Using the shortcut menu You can now export tabular data that you find on a Web page to Excel using the shortcut menu. Right-click on the data and choose Export to Microsoft Excel. This feature allows you to start the process of creating a Web query right from within Internet Explorer.

Using the Edit button Another way to get tabular data from a Web page into an Excel workbook is to use the Edit button in Internet Explorer. This button includes Excel as a valid editor for all Web pages. When you find data that you would like to export to Excel, click the down arrow next to the Edit button and click Edit with Microsoft Excel."

Doesn't work in FF though, but the person that needs to do this is using IE so all sorted

samhail

That actually used to annoy me too. I have that kinda application when i copy from my bank details online to excel.

try hitting ctrl a on the page, or select the text outside of the table aswell as the table itself.
Its messy, espicially if there are images on the page since they are copied into excel too.

let me know if you get what i mean

fletch

Copying outside the table seems to work too, thanks samhail