Displaying Excel data in forum posts

[tescor]

Hi there,

Please can someone advise if I can easily convert Excel data into a table layout in a PH forum post?

Formatting Help shows this for a table

->||=Heading=||=Heading 2=||
->|| Cell1 || Cell2 ||

Heading	Heading 2
Cell1	Cell2

Is there a simple way of getting my Excel data into that format please?

[tescor]

bigpriest said:

If you had three columns of data in A,B and C, then in D you'd enter a formula like:

="||="&A1&"=||"&B1&"=||"&C1&"=||"

Then copy the formula down column D.
Copy and paste the results from column D into your post.

Thanks, I can do that, but it's quite a manual job to do that each time, and for each column. I'll give it a go and see how much work is involved.

I was hoping for a website that would let me paste in my copied cells from Excel, and produce the correct format