I have about 1 millions lines of lithology description that were noted with lots of abbreviations and now needs to be converted to text
I have attached an excel where it is shown how this should look like.
The abbreviations are inconsistent in the order of appearance and sometimes spelling.
The separation of abbreviation can be space , comma, tab, or hyphen but not all in one line
The VBA should allow the user to add additional terms to the abbreviation dictionary
The programmer needs to expect interaction with the client to perfect the tool (*10 hours)
You need to be fluent in English and close to an European time zone