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 name]

 

first namelast name
 / No spend

 

Any help would be appreciated.  Thank you!

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. 

5 Replies

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

      Thank you!  I added the replaced the first name and last name values "/" with nothing step before concatenation but I am still getting null.  Any idea why?

      • j_ocean's avatar
        j_ocean
        Icon for Helper V rankHelper V
        2 years ago

        I'm not sure, but maybe try using Text.Combine vs &.