I have a formula that pulls text from another file. I want to pull a number from the Formula but instead I get the section from the text the formula is returning. Any suggestions on how to get the number not the text?
Formula (in Cell C14):
='[2021 Data Sheet.xlsm]30246'!$C$6
Data formula returns:
Red Small Apples -Red Delicious
I want to pull the number 30246 from the formula. I tried to use the MID formula, but it returns the Text data not the number form the formula.
=MID(C14,23,5) returns Delic not 30246.
I would appreciate any suggestions you might have. Thank you
Formula (in Cell C14):
='[2021 Data Sheet.xlsm]30246'!$C$6
Data formula returns:
Red Small Apples -Red Delicious
I want to pull the number 30246 from the formula. I tried to use the MID formula, but it returns the Text data not the number form the formula.
=MID(C14,23,5) returns Delic not 30246.
I would appreciate any suggestions you might have. Thank you