Limit Text length in cell with formula by Data Validation Question

Hi

Can I limit the text length in a cell that contains a formula? You may say "Limit the text length in the input cell". That can't be done because the formula in the resultant cell takes text from two other cells in addition to the input cell. I need to limit the overall text length to, let say, 50 characters.

Does that make sense??

Thanks.

Hi Glenn

Thanks for your quick response. I am afraid that that is way off. Probably due to my explanation. Can't add a file here so I'll try as below.

ColumnA ColumnB ColumnC

Enter Txt Text ="enter txt"&" "&"Text"

Let say, the Text cell contains the text "O'Riley" and in the "Enter Txt" cell I want to enter text so the result in ColumnC cannot go over 50 characters. I'd like to know whether I can use Data Validation to limit the number of characters in ColumnC to 50?

Better?

Now I can add a file. So, here it is explained.

Thanks

Try it this way.

Originally Posted by popipipo

Try it this way.

Hi There

That is good.

Can you show me on which cell you have place the Data Validation? How does one copy it down the column? Copy>paste?

Thanks

The datavalidation are in Cells A2:C2
The most logic way is:
copy
paste special
datavalidation