Copy Word Table To Excel Without Splitting Cells - 1 MINUTE

Did I solve your problem in less than 1 minute? Then please help me out 🙌😊by subscribing to the channel and liking the video.
When you have line breaks or paragraph breaks in a table in Word and copy it into Excel, then by default the cell will be split in Excel. So, how we copy a Word table to Excel without splitting cells? This is what you will learn in this video. I'll actually show you 2 ways to copy a table a keeping the cells merged. The first option takes a bit more time but it can be used offline and you only need Word and Excel for it. The second options is extremely fast but you will need internet access for it.
00:00 Copy Word table to Excel - Option 1
01:07 Copy Word table to Excel - Option 2
#1minutesolutions

[@LeonRenner]

If this video helped you, you could do me an awesome favor and destroy that like button 😍🙌 Thanks a lot!

[@claudiawohl5508]

Thanks so much from translator Claudia in Israel!! The workaround with Google Sheets was soooooo easy and quick!

[@LeonRenner]

I'm glad I could help :)

[@Poli-hj9pw]

Thank you so much! You saved me hours of time via the google sheets method. Priceless....

[@LeonRenner]

Glad to hear that :)

[@migueldsouza9695]

I had to update a 200 page table in a 15yr old Word document that has had continuous modifications during that time. The only way to do it was to convert it to Excel, BUT, it put everything in seperate cells. This video has quite possibly saved my sanity!

[@LeonRenner]

I'm glad to hear that I was able to contribute to you keeping your sanity :D

[@ndivhuhothavhana]

Oh my goodness , thank you for saving me hours and hours and days of work. God bless you

[@LeonRenner]

You‘re very welcome 🙏 glad I could help 😊❤️

[@colettelevesque249]

I used the Google Sheet method. So easy! What a time saver. Thank you!

[@LeonRenner]

Thanks for the feedback! Glad I could help ☺❤

[@sciencelearning2326]

Amazing and helpful video, thanks a lot for these short and easy tricks

[@LeonRenner]

Happy to help :)

[@djapcrumhorne4538]

Thank you Mr Renner, you've saved me a great deal of pointless work 👍

[@LeonRenner]

Glad to help 😊❤️

[@user-rd3dv7rj3f]

Brother, you helped me immensely with this one. Don't know what I would do without this video. Thank you!

[@LeonRenner]

Thanks for the great feedback 😊💗

[@nyamka0510]

Dude you have no idea how much time you saved for me. Thanks

[@LeonRenner]

You're very welcome 😊❤️

[@justirinigozum]

Google Sheets worked for me! Thank you! :)

[@LeonRenner]

Glad to hear! You're very welcome ❤☺

[@reutelimelech3426]

Thank you champion!
I tried many things until I found your video

[@LeonRenner]

Thank you 🙏 😊

[@juliewatson9140]

This is so easy!!! I would have done the Find and Replace, but I am copying about 50 pages from Word into Excel and that made me very nervous. Finding your video and using the Google Sheets method was a huge time and worry saver. Thank You!!!!

[@LeonRenner]

Glad to hear that, Julie ❤🙌

[@anoopcjoseph9514]

Thank you so much for this hack 😊 So grateful

[@LeonRenner]

Glad I could help :)

[@user-hn5nf1up6i]

THANK YOU!!

[@LeonRenner]

You‘re welcome 😊❤️

[@mikulshah5551]

Thanks... this helped me a lot

[@LeonRenner]

Glad to hear that :)

[@ahaconsulting2659]

worked for me, thanks

[@LeonRenner]

You're welcome :)

[@olgaromanova218]

thank you!!!

[@LeonRenner]

You're welcome!☺️❤️

[@tuananhtran7518]

thank you very much

[@LeonRenner]

You are welcome 😊❤️

[@claudiawohl5508]

Hi. Amazing. Thank you. It worked with the Google Sheet. However I did not manage to do it with the first option, because my Excel did not allow me to type the Alt+ characters in the Find-Replace window. Any alternatives to this?

[@LeonRenner]

Glad that it worked.
Well, theoretically you can also simply copy the formatting symbol from the Excel cell and paste it into the "Find" field and then click into the "Replace" field and press CTRL + J. This should also do the trick :)

[@majidzf]

Perfect

[@LeonRenner]

Thank you 😊❤

[@doop6995]

good man

[@LeonRenner]

Thank you 😊❤️

[@sciencelearning2326]

how to avoid the calculation of data (cells that contain minus at beginning) when copy table from word to excel?

[@LeonRenner]

not a 100% sure, but my best guess is to use the find-and-replace function in Word and replace every " - " with a " '- ". The apostrophe should keep the cells safe in Excel.

[@sciencelearning2326]

Thank you very much my friend your method is working🙏

[@thedatasync5248]

I can't believe how easy the Google Hack was; thanks!

[@LeonRenner]

You're welcome :)

[@nitrogenium]

thx!

[@LeonRenner]

You're very welcome 😊❤