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
|