Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replace a cell if value is alphabetic
I have this chart where I need to combine the contents of 2 cells - A & C -
But if A is alphabetic I need it to combine B & D instead. Any good ideas? A B C D WC1 406 20062442 93082813 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replace a cell if value is alphabetic
Hi
Presuming by 'combine' you mean add, you could try something like this: =IF(ISTEXT(A1),B2+D2,A2+C2) Hope this helps. Andy. "Hejde" wrote in message ... I have this chart where I need to combine the contents of 2 cells - A & C - But if A is alphabetic I need it to combine B & D instead. Any good ideas? A B C D WC1 406 20062442 93082813 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replace a cell if value is alphabetic
Hi Andy
No, I mean combine :o) What I have done is this simple formula: =A1&"-"&C1 - The result becomes WC1-20062442 - But as I wrote in my inicial message, if A is alphabetic I need it to combine B & D instead. Do you know how to do that? Thanks :o) "Andy" skrev: Hi Presuming by 'combine' you mean add, you could try something like this: =IF(ISTEXT(A1),B2+D2,A2+C2) Hope this helps. Andy. "Hejde" wrote in message ... I have this chart where I need to combine the contents of 2 cells - A & C - But if A is alphabetic I need it to combine B & D instead. Any good ideas? A B C D WC1 406 20062442 93082813 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replace a cell if value is alphabetic
Sorry!
Try this: =IF(ISTEXT(A1),B2&"-"&D2&"-",A2&"-"&C2&"-") or =IF(ISTEXT(A1),CONCATENATE(B2,"-",D2,"-"),CONCATENATE(A2,"-",C2,"-")) Andy. "Hejde" wrote in message ... Hi Andy No, I mean combine :o) What I have done is this simple formula: =A1&"-"&C1 - The result becomes WC1-20062442 - But as I wrote in my inicial message, if A is alphabetic I need it to combine B & D instead. Do you know how to do that? Thanks :o) "Andy" skrev: Hi Presuming by 'combine' you mean add, you could try something like this: =IF(ISTEXT(A1),B2+D2,A2+C2) Hope this helps. Andy. "Hejde" wrote in message ... I have this chart where I need to combine the contents of 2 cells - A & C - But if A is alphabetic I need it to combine B & D instead. Any good ideas? A B C D WC1 406 20062442 93082813 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replace a cell if value is alphabetic
Thanks Andy - That was just the one I needed!
"Andy" skrev: Sorry! Try this: =IF(ISTEXT(A1),B2&"-"&D2&"-",A2&"-"&C2&"-") or =IF(ISTEXT(A1),CONCATENATE(B2,"-",D2,"-"),CONCATENATE(A2,"-",C2,"-")) Andy. "Hejde" wrote in message ... Hi Andy No, I mean combine :o) What I have done is this simple formula: =A1&"-"&C1 - The result becomes WC1-20062442 - But as I wrote in my inicial message, if A is alphabetic I need it to combine B & D instead. Do you know how to do that? Thanks :o) "Andy" skrev: Hi Presuming by 'combine' you mean add, you could try something like this: =IF(ISTEXT(A1),B2+D2,A2+C2) Hope this helps. Andy. "Hejde" wrote in message ... I have this chart where I need to combine the contents of 2 cells - A & C - But if A is alphabetic I need it to combine B & D instead. Any good ideas? A B C D WC1 406 20062442 93082813 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replace a cell if value is alphabetic
Thanks for the feedback - glad to help!
Andy. "Hejde" wrote in message ... Thanks Andy - That was just the one I needed! "Andy" skrev: Sorry! Try this: =IF(ISTEXT(A1),B2&"-"&D2&"-",A2&"-"&C2&"-") or =IF(ISTEXT(A1),CONCATENATE(B2,"-",D2,"-"),CONCATENATE(A2,"-",C2,"-")) Andy. "Hejde" wrote in message ... Hi Andy No, I mean combine :o) What I have done is this simple formula: =A1&"-"&C1 - The result becomes WC1-20062442 - But as I wrote in my inicial message, if A is alphabetic I need it to combine B & D instead. Do you know how to do that? Thanks :o) "Andy" skrev: Hi Presuming by 'combine' you mean add, you could try something like this: =IF(ISTEXT(A1),B2+D2,A2+C2) Hope this helps. Andy. "Hejde" wrote in message ... I have this chart where I need to combine the contents of 2 cells - A & C - But if A is alphabetic I need it to combine B & D instead. Any good ideas? A B C D WC1 406 20062442 93082813 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
replace one tag in content of one cell and format not changed | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions |