copying a table from this form to excel

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
I was reading another post in this form and that post has a table like the one below. So I tried it to copy that table from this form to excel. but did not work, they all ended up in one cell. How can I copy a table from here (this form, like the one below) to excel? is that possible? Thank you very much.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Age[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]44[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]55[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
You can copy directly from the forum.....IF you highlight from outside of the borders of the not just the data within the boxes
So, in this case, if you highlight from the end of...."thank you very much" down to just above the "reply" bar, it should paste correctly !
 
Upvote 0
I always wonder how they post a Table like above into this forum.
When I try it only paste the data and not the borders even thou my Table has borders
 
Upvote 0
Paste your data. Then select "Table Properties" icon (the second one, after Table icon). It will pick your Rows # and Col #. Just click on Table Style menu and select Full Grid. Hope that helps.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top