concatenate

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

I am trying t convert 2 cells, but i only want to merge if the total
characters does not exceed 70 characters, can anyone help me with a formula
for that?
 
Hi
I am not sure if this is what you want:

IF(LEN(A1)+LEN(B1)<=70,CONCATENATE(A1,B1),"")
check both columns if less than 70 = concatinate both, if not blank
or
LEFT(CONCATENATE(A1,B1),70)
this concatenate both cells up to 70 characters

--
Please click "yes" if this post helped you!

Greatly appreciated

Eva
 
Joe,

In your message header you mention 'Concatenate' and in the message body it
becomes 'Convert' and then 'Merge' so I'm a bit lost as to what you actually
want. Does this help

=IF(LEN(A1&B1)<70,A1&B1,"")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top