Copy table from word to excel ...

I just had to convert a word table (nicely formatted with bullet list, etc.) into an excel table.

The native approach with Copy and Paste does not work as each bullet in the list results in an own cell in excel.

Approach:

1) Select the table in word
2) Replace '^p' with ';'
3) Replace '^l' with ';'
4) Format bullet list to no bullet list
5) Replace ';;' with ';' ...

Copy - Paste