Require help with TRIM function

[shahs]

I have already an argument in conditional formatting which is

Formula is =LEN(C13)>64

This is to alert the user that they have exceeded the 64 char limit, but I now need to add to this argument to include the TRIM function, the TRIM function should alert when there are spaces before or after the text.

What I need to know is how do I combine the LEN and TRIM statment in one conditional statement. I only have two condition formatting options and the other one is used, hence why I need to combine the two statements in to one argument.

Thanks.

 

[NBVC]

=OR(LEN(C13)>64,LEN(TRIM(C13))<>LEN(C13))

edit: forgot to put Len() function around Trim() function.

 

[fairwinds]

Welcome to the board!

Try:

=(LEN(C13)>64)+(LEN(C13)<>LEN(TRIM(C13)))

 

[Richard Schollar]

Hi

Try:

=OR(LEN(C13)>64,LEN(TRIM(C13))<LEN(C13))

This isn't perfect, as if your user has intentionally inserted a double space within whatever text he's written, TRIM will highlight this as a problem.

Best regards

Richard