Formula To Link If Less Than, Display Otherwise If Greater Than

Would a formula in Cell B1 be able to do this, or would I need code?

Display value of Cell A1 if value in Cell A1 = 20 or less characters; if more than 20 characters, then display 'SEE CELL C1' and display Cell A1 value in Cell C1.

I could do this with a formula in Cell B1 and a formula in Cell C1, but Cell C1 must not contain a formula.

Any thoughts?

Hello

Place this formula in B1:
=IF(LEN(A1)<=20,A1,"See Cell C1")
Place this formula in C1:
=IF(B1="See Cell C1",A1,"")

Regards..

Thank you jraj1106, I realize that is an easier option, but Cell C1 must not contain a formula. Is there a way to combine those two formulas into one formula that would go into Cell B1?

Does anyone know how I could do this? I'd really appreciate it.

If not formula, VBA might be able to help you. Let me work this out.

Right click on the sheet that has the data in it, select "View Code". Then copy this code over.

Please Login or Register  to view this content.

Thank you so much, arlu1201!

That looks like it will work beautifully, however, this is current code of the sheet I'm using:

Please Login or Register  to view this content.

What's the right way of 'merging' two Worksheet_Change codes?

Originally Posted by arlu1201

Right click on the sheet that has the data in it, select "View Code". Then copy this code over.

Please Login or Register  to view this content.

just fyi neither of those exit subs are needed and they may cause problems when you come to merge that into the existing change event.

Thanks Joseph.

I put the Exit subs because the subs were taking long to execute.

And i agree with you that they need to be removed while merging the codes.

Originally Posted by arlu1201

I put the Exit subs because the subs were taking long to execute.

but they don't do anything.

So where would I insert that?

Does anybody know? I'm stuck.

Anyone at all?

Please do not bump your thread so often. It will irritate others.

So where would I insert that?

What are you talking about?

Thank you for your reply, arlu1201. I have no intentions of irritating anyone, I suppose I'm getting somewhat desperate for a solution which I needed about a week ago. My apologies.

I'm simply asking how to merge this code:

Please Login or Register  to view this content.

..with this one:

Please Login or Register  to view this content.

..since my attempts have all failed - I don't the right way of doing so.

I'll mark this as solved and ask about merging in a new thread. Thank you for your help.