How to replace a cell if value is alphabetic

[Guest]

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

 

[Guest]

Hi

Presuming by 'combine' you mean add, you could try something like this:
=IF(ISTEXT(A1),B2+D2,A2+C2)

Hope this helps.
Andy.

 

[Guest]

Hi Andy

No, I mean combine ) 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 )

"Andy" skrev:

 

[Guest]

Sorry!
Try this:
=IF(ISTEXT(A1),B2&"-"&D2&"-",A2&"-"&C2&"-")
or
=IF(ISTEXT(A1),CONCATENATE(B2,"-",D2,"-"),CONCATENATE(A2,"-",C2,"-"))

Andy.

 

[Guest]

Thanks Andy - That was just the one I needed!

"Andy" skrev:

 

[Guest]

Thanks for the feedback - glad to help!

Andy.

Thanks Andy - That was just the one I needed!

"Andy" skrev: