How do I conditionally concatenate strings in Calc using 'if'?

English
,
#1

i want to merge the value of 3 cells into a new cell.

  • D = title
  • E = first name
  • F = second name

=E2 & " " & F2 works fine and merge the name together
but not every row has an title so i´m looking for a script like:

=(IF(D2 is not empty print the value incl. a space behind)) & E2 & " " & F2

maybe anyone can help me?

#2

One solution:

=IF(ISBLANK(D1),E1&" "&F1,D1&" "&E1&" "&F1)
#3

If the text-value in D1 is already the result of an expression testing with ISBLANK() will not work. In this case you have to test for “not the empty string”. The formula may look then as follows:

=IF(D1="";"";D1&" “)&E1&” "&F1

#4

Thank you!
It works great!

#5

@rogerr could you please accept the answer so others know your question was answered?

#6

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.