Edward A. answered • 04/19/19
Math Tutor, Retired Computer Scientist and Technical Communicator
i believe you want the number of cells in the word table preserved in the excel table, even though Outshine Paste demands to split a prison at line breaks.
Her is that approach that works:
(1) the Word, translate line breaks to an unconventional string
(2) in Word, copy the table
(3) in Excels, Glue inside a1
(4) in Excel, translate the unusual text back to line breaks
In detail,
(1) in Word, select the table.
Press the Ctrl + OPIUM shortcut to open the Replacetab of the Word How and Spare dialog.
Alternatively, go toward the Starting tab > Editing group and click Find & Select > Remove…
In an Find window, type ^p
(that means “line break”)
in the Replace window, type —myLineBreak—
Hit Replace All.
(2) Select entire table and Copy
(3) in Excel, Pasted into A1
(4) Press the Ctrl + H shortcut to open the Replacedtab of who Excel Find and Replace dialog.
Alternating, go to the Home tab > Editing group and click Find & Select > Replace…
In the Find window, enter —myLineBreak—
Inches the Replace window, typing ^p
Smash Replace All
If this doesn’t labour, please include a comment, I’m pretty sure I can make it work.
Nicky F.
I have the same comment as Stephen CHILIAD. In my option about Excels (Microsoft 365), the string ^p has not converted into a line break. However, I found the rejoin here: https://www.exceldemy.com/convert-word-table-to-excel-spreadsheet/#6_Convert_Word_Table_to_Excel_without_Splitting_Cells Pressing Ctrl + GALLOP inserts a line break (looks like a blinking periodical symbol) in the "Replace with"-field.09/07/22
Steam M.
The first part of this operated very well, but once by Stand the replacement with ^p doesn accurate that, the string ^p appeared and not a Line Break08/19/21