how to add a formula in the Input Message of Data Validation in Excel

Yang, Shu Zi (TC/TC) 0 Reputation points
2023-08-25T19:24:25.83+00:00

Hi all,

We have many columns whose cells have length limit. We hope during typing, users can get a kind of reminder about the number of letters still within the limit. the right place looks like to be the Input Message in the Data validation section and the question is how to write a formula inside of the Input Message box to tell how many letters are still allowed to input.

thanks in advance,

Sheldon.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,141 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.