Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate
Maybe something like this...
=IF(LEN(A1&B1)70,"",A1&B1) -- Biff Microsoft Excel MVP "joe" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Un-Concatenate | Excel Discussion (Misc queries) | |||
Help with CONCATENATE! | Excel Discussion (Misc queries) | |||
CONCATENATE | Excel Discussion (Misc queries) | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
concatenate | Excel Worksheet Functions |