Hi,

I would like to split the contents of a cell into two other cell,
however I am unsure if it is possible in this case.

Here is an example of what I have in each cell:

English word German word

All the cells are the same, with the english word followed by the
German word, The German word is written in bold font and the English
word is not. Is there any way of splitting cells by using the bold
text? There is no other delimeters such as commas in the cells. Also
the words are different lengths and some phrases of 2 or 3 words are
also included

Thanks in advance.