Formula
Hi, can someone help me with a formula for this:
in A1 31.112.2015 I want the formula for A2 as follows, when A1 is not empty then leftstring4.
any idea?
OS X Yosemite (10.10.3)
Hi, can someone help me with a formula for this:
in A1 31.112.2015 I want the formula for A2 as follows, when A1 is not empty then leftstring4.
any idea?
OS X Yosemite (10.10.3)
=if(A1="", "", left(A1, 4))
if a1 really contains "31.112.2015" the I would expect this to return "31.1"
if you want "2015" then use the formula:
=if(A1="", "", right(A1, 4))
Hi valbogatan,
A variation on Wayne's approach would use LEN() to determine if there is an entry in A1
=IF(LEN(B2)>0,left(A1, 4),"")
quinn
Tks to both of You.
regards
Olaf
Formula