Forum Discussion

Marcegon's avatar
Marcegon
Icon for Helper II rankHelper II
2 years ago
Solved

I need help with a concatenate formula

I am using the following formula to concatenate first and last name.  However, it does not work when the last name starts with a slash (/).  It gives me a null cell.     =[first name]&" "&[last nam...
Need Help
  • Marcegon's avatar
    Marcegon
    2 years ago

    Thank you!  I replaced "null" (since the first name does not have a value/text) with space and it worked. 

ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
2 years ago
=([first name] ?? "") & " " & ([last name] ?? "")