Can someone help me to achieve the desired results with a single formula?
A1 -> Ludwig van Beethoven
B1 -> 1770/12/17 - 1827/03/26
result: Ludwig van Beethoven (1770-1827)
A2 -> Jens Becker
B2 -> 1965/05/24
result: Jens Becker (1965)
A3 -> Jim Gilmour
result: Jim Gilmour
What I want is to get the whole A1 cell plus
if the B1 cell has a value, " ("
LEFT (B1, 4)
if there is not a death date, ")"
"-" plus "death year" plus ")"