extract an element out of a single-cell array

[mfragugl]

Is there a formula that I can use to extract an element from an array that exists within one cell?

Capture.PNG

[MrShorty]

Are you required to use Excel formulas only, or can you use a different spreadsheet? Google Sheets has a SPLIT() function that will do this easily =SPLIT(F1,"[],",TRUE,TRUE) will split the text into the three numeric elements (SPLIT() function documentation: https://support.google.com/docs/answer/3094136?hl=en ). Then use the INDEX() function to choose one element =INDEX(SPLIT(...),2) to get the 2nd number.

Any chance that will work for you?

[Rick Rothstein]

Is there a formula that I can use to extract an element from an array that exists within one cell?

What element? Exactly what are you trying to do? Can you provide a little more explanation of your ultimate goal?

[mfragugl]

Thanks MrShorty! That split function was exactly what I needed!

[MrShorty]

Glad that worked for you. To my knowledge, Google Sheets is the only spreadsheet that supports the SPLIT() function, so this solution will only work in Google Sheets (at least until the other spreadsheets incorporate this function). As long as you don't need this to export to Excel or other spreadsheet, then it appears to work for you.