- #Copy word table to excel without line breaks windows 10
- #Copy word table to excel without line breaks windows
Click this to paste while removing the formatting. Select the cells you want to format like the original, right-click, and select the formatting icon. This will show some new icons, including a Paste as text icon that shows a clipboard and the letter A. You can copy just the formatting of a cell by selecting the cell, then type Control+C to copy. This should look as follows: Now convert this into a table by highlighting it all (you. Unfortunately I get Object required message. The word document is active (however I must admit that if I want to run the macro the excel will be activated), and the first cell contains already line break (basically every cell has line breaks). On the menu that appears, click the three-dot button next to the item that you want to paste without formatting. Open a new Word document and paste the copied text by pressing Ctrl V. Manually I copied the content to excel and checked the line break character with CODE() formula. Now, you can press Win + V to access anything you've copied in the past. Here, toggle on Clipboard history to enable the built-in manager.
#Copy word table to excel without line breaks windows
It takes a few extra clicks compared to the above method, so it's not perfect, but still worth knowing about.įirst, make sure you're using the improved clipboard manager in Windows 11 by going to Settings > System > Clipboard. If you're using Windows 11, you can use the built-in clipboard manager to paste without formatting.
#Copy word table to excel without line breaks windows 10
It's a simple utility, but it makes the action of pasting without formatting on Windows 10 or Windows 11 incredibly easy. Make sure Automatically run PureText when Windows starts is selected so you don't have to start it manually, and you're all set. Copy the data you want to paste into Word, and then right click the Word document where you want to paste the data, then choose Keep Text Only option under the Paste Options section, see screenshot: 2. You'll likely want to disable Play a sound, as there's no reason to hear an annoying chime every time you paste. When you copy the data from Excel file and paste it as text only in Word, the table will be removed at once, please do as follows: 1.