Copy Word Table To Excel Without Splitting Cells

No video

Copy Word Table To Excel Without Splitting Cells - 1 MINUTE

Рет қаралды 27,315

Күн бұрын

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

Пікірлер: 57

@LeonRenner Жыл бұрын

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

@brucenelson7644 18 күн бұрын

converting through google sheets is genius. I don't think I would ever have come up with that one.

@LeonRenner 13 күн бұрын

Glad you liked that solution :)

@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 :)

@migueldsouza9695 5 ай бұрын

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 5 ай бұрын

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

@djapcrumhorne4538 7 ай бұрын

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

@LeonRenner 7 ай бұрын

Glad to help 😊❤️

@Poli-hj9pw 3 ай бұрын

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

@LeonRenner 3 ай бұрын

Glad to hear that :)

@ndivhuhothavhana 10 ай бұрын

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

@LeonRenner 10 ай бұрын

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 ☺❤

@nyamka0510 10 ай бұрын

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

@LeonRenner 10 ай бұрын

You're very welcome 😊❤️

@user-rd3dv7rj3f 10 ай бұрын

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

@LeonRenner 10 ай бұрын

Thanks for the great feedback 😊💗

@justirinigozum 11 ай бұрын

Google Sheets worked for me! Thank you! :)

@LeonRenner 11 ай бұрын

Glad to hear! You're very welcome ❤☺

@sciencelearning2326 Ай бұрын

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

@LeonRenner Ай бұрын

Happy to help :)

@juliewatson9140 11 ай бұрын

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 11 ай бұрын

Glad to hear that, Julie ❤🙌

@reutelimelech3426 8 ай бұрын

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

@LeonRenner 8 ай бұрын

Thank you 🙏 😊

@anoopcjoseph9514 6 ай бұрын

Thank you so much for this hack 😊 So grateful

@LeonRenner 6 ай бұрын

Glad I could help :)

@mikulshah5551 5 ай бұрын

Thanks... this helped me a lot

@LeonRenner 5 ай бұрын

Glad to hear that :)

@ahaconsulting2659 5 ай бұрын

worked for me, thanks

@LeonRenner 5 ай бұрын

You're welcome :)

@user-hn5nf1up6i 10 ай бұрын

THANK YOU!!

@LeonRenner 10 ай бұрын

You‘re welcome 😊❤️

@olgaromanova218 4 ай бұрын

thank you!!!

@LeonRenner 4 ай бұрын

You're welcome!☺️❤️

@tuananhtran7518 6 ай бұрын

thank you very much

@LeonRenner 6 ай бұрын

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 7 ай бұрын

Perfect

@LeonRenner 6 ай бұрын

Thank you 😊❤

@doop6995 8 ай бұрын

good man

@LeonRenner 8 ай бұрын

Thank you 😊❤️

@abhishekpanthangi8878 8 күн бұрын

In excel.. after clicking on CTRL+H, then ALT 0182, it is not showing me that symbol

@LeonRenner 6 күн бұрын

There has been a similar question about a month ago. Feel free to look through the most recent comments to see the answer on that :)

@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🙏