Copy Word Table To Excel Without Splitting Cells

Copy Word Table To Excel Without Splitting Cells - 1 MINUTE

Рет қаралды 31,680

Leon Renner

Күн бұрын

Пікірлер: 67

@LeonRenner Жыл бұрын

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

@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 ❤🙌

@nyamka0510 11 ай бұрын

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

@LeonRenner 11 ай бұрын

You're very welcome 😊❤️

@mikulshah5551 7 ай бұрын

Thanks... this helped me a lot

@LeonRenner 7 ай бұрын

Glad to hear that :)

@djapcrumhorne4538 8 ай бұрын

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

@LeonRenner 8 ай бұрын

Glad to help 😊❤️

@claudiawohl5508 3 ай бұрын

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

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

@abhishekpanthangi8878 Ай бұрын

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

@LeonRenner Ай бұрын

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

@kieudang1909 9 күн бұрын

Oh my god thank you! You saved me 5 hours of manual typing and replacing

@LeonRenner 5 күн бұрын

Glad I could help!

@brucenelson7644 2 ай бұрын

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

@LeonRenner 2 ай бұрын

Glad you liked that solution :)

@jamesruge 23 күн бұрын

thank you so much, the google sheet really helped me

@LeonRenner 21 күн бұрын

Glad I was able to help :)

@justirinigozum Жыл бұрын

Google Sheets worked for me! Thank you! :)

@LeonRenner Жыл бұрын

Glad to hear! You're very welcome ❤☺

@ivandelvalle2784 Ай бұрын

bro saved my day, are you a god?

@LeonRenner 27 күн бұрын

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

@migueldsouza9695 7 ай бұрын

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

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

@amyharth5446 Ай бұрын

I used the first method for a table over 600 rows and it worked! Thank you so much!!!

@LeonRenner 27 күн бұрын

Glad it helped!

@claudiawohl5508 2 ай бұрын

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

@LeonRenner 2 ай бұрын

I'm glad I could help :)

@Bondoz007 Ай бұрын

Excellent - thanks

@LeonRenner Ай бұрын

You're welcome :)

@sciencelearning2326 3 ай бұрын

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

@LeonRenner 3 ай бұрын

Happy to help :)

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

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

@LeonRenner 5 ай бұрын

Glad to hear that :)

@DenisKolesnik-b7k Жыл бұрын

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 😊💗

@reutelimelech3426 10 ай бұрын

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

@LeonRenner 10 ай бұрын

Thank you 🙏 😊

@ndivhuhothavhana 11 ай бұрын

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

@LeonRenner 11 ай бұрын

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

@sciencelearning2326 3 ай бұрын

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

@LeonRenner 3 ай бұрын

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

Thank you very much my friend your method is working🙏