Forum Discussion
IF formula not listing all the information from target cell. Is there a limit on data in cells?
I have a TEXTJOIN IF formula that works but in the target location i get a #VALUE. I went looking on why and couldn't find a reason. I noticed that the cell it was grabbing would work if there was maybe 50 characters of text in the cell. I had 137 characters. is there a way to increase the amount of information pulled from a cell? It works normally if i do a regular =A21 for example. It doesn't even grab part of the information, i just get the #VALUE. I just don't know why it wont grab all the information in the cell. Its almost like once i put an array to it it wont work.
This should be array, you must once you finish type the formula, press Ctrl+Shift+Enter at the same time
- Those were examples. in the picture i show what I'm talking about. if the cell has too many characters inside it for some reason it wont return properly unless i single out the cell.
- I missed that, I just updated my answer,
once you write the formula just press Ctrl+Shift+Enter at the same time
