concatenate
in [Functions]
|
From: joe on 2 Mar 2010 14:51 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?
From: Eva on 2 Mar 2010 15:01 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" wrote: > 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?
From: T. Valko on 2 Mar 2010 15:01 Maybe something like this... =IF(LEN(A1&B1)>70,"",A1&B1) -- Biff Microsoft Excel MVP "joe" <joe(a)discussions.microsoft.com> wrote in message news:E6A78970-5608-4A0B-BCDD-88EAB59E66D0(a)microsoft.com... >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?
From: Paul C on 2 Mar 2010 15:03 try this IF(LEN(A1)+LEN(B1)<71,concatenate(A1,B1),"") -- If this helps, please remember to click yes. "joe" wrote: > 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?
From: Mike H on 2 Mar 2010 15:06 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. "joe" wrote: > 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?
|
Pages: 1 Prev: Automic allocation of numbers Next: Conditional Formatting - Inserting Rows |