Forum Discussion
Excel Text Validation Help
I've been working on a excel form for one of our businesses and I'm attempting to use data validation to limit characters in 3 lines of text using =CELL("contents", C8) etc.. but it is not working. A...
SergeiBaklan I believe C8 is attempting return the entire formula in that cell. It appears =value(C8) is producing the intended results.
Hello TimothyE,
An additional note. Your If() statement is rather lengthy. I would suggest creating a new worksheet with the Item in column A and the character lengths in column B. Then refer to this worksheet in cells C8, C10, and C12 as follows:
=Index(Sheet2Array, Match($B$3,Sheet2Array[Item],0),1)
If you want to restrict customers from accessing this worksheet, you may hide it and/or protect the worksheet.
Hope this helps!
PReagan