Hi Sarah. You can use Replace to remove the spaces. The bolded section
in the equation below is what I used on a project custom form that will
replace spaces with an underscore. The equation would need to change a
bit if you are adding the custom field to a different object or if you
are just creating a calculated column in a report/view. CONCAT(Reference
Number,REPLACE(Name," ","_")) The result for a Project A with a
reference # of 123 would be: 123Project_A Hope this helps!