I need help with a concatenate formula

[Marcegon]

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 name	last name
	/ No spend

Any help would be appreciated.  Thank you!

[ThxAlot]

=([first name] ?? "") & " " & ([last name] ?? "")

[j_ocean]

Run a replace "/" with "" before the concatenation.

[Marcegon]

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]

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

[Marcegon · Accepted solution]

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