Forum Discussion
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...
Thank you! I replaced "null" (since the first name does not have a value/text) with space and it worked.
