How to replace a cell if value is alphabetic

H

Hejde

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
 
G

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.
 
H

Hejde

Hi Andy

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

"Andy" skrev:
 
G

Guest

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

Andy.
 
Top