Hi,
First of all I've tried searching for this here (and other sites) but I haven't found anything that has worked for my data so far. So I would be endlessly appreciative of any help.
I have a worksheet that currently comprises of a single column.
The data, taken from an Italian to English dictionary, comprises headwords, definitions, grammatical indicators, and example sentences/phrases. It's these phrases that I'm interested in extracting.
They're formatted in a single cell as: italian phrase english translation
I want to separate the two phrases into two different columns, so that the result is:
A______________B
Italian phrase____English translation
There are no regular markers (e.g. a semicolon or hyphen), otherwise I'd go to "text to columns". Is it possible to split a single cell according to bold/non-bold formatting? (The rest of the data I'm not interested in, so I'd like to delete/disregard them.)
Any help would be massively appreciated, as I've got 28,000 rows to sort through!
Bookmarks