I am creating a cheat sheet which grabs cell values from another sheet. Currently, I use the MID function to produce a certain string of text within the reports.
However, there is a certain cell which provides a value which is either 28 string long or 32 string. So far I am using this formula:
=IF(LEN([c14.xls]Sheet1!$A$197)>28,[MID([c14.xls]Sheet1!$A$197,8,15)],[MID([c14.xls]Sheet1!$A$197,8,15)])
This function does not currently work. Basically, my goal is to grab a certain string from the cell when the text is 28 and grab a different value when the text string is 32.
Thank you.
However, there is a certain cell which provides a value which is either 28 string long or 32 string. So far I am using this formula:
=IF(LEN([c14.xls]Sheet1!$A$197)>28,[MID([c14.xls]Sheet1!$A$197,8,15)],[MID([c14.xls]Sheet1!$A$197,8,15)])
This function does not currently work. Basically, my goal is to grab a certain string from the cell when the text is 28 and grab a different value when the text string is 32.
Thank you.
