I'm facing an issue when trying to convert a specific date format into name of month. Supermetrics, an addon for Google Spreadsheets, returns date formats like the following: 2016|08, etc.I have tried several solutions from the documentation without any luck. Any solutions or specific functions that I should look for? 
Trying to convert this date format 'year|month into name of Month using Google Sheets
google spreadsheets