concatenate

[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?

 

[Eva]

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

 

[T. Valko]

Maybe something like this...

=IF(LEN(A1&B1)>70,"",A1&B1)

 

[Paul C]

try this

IF(LEN(A1)+LEN(B1)<71,concatenate(A1,B1),"")

 

[Mike H]

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.