Need to build a complete address from distinct parts in Excel? The join function is your go-to solution! This useful tool allows you to fuse multiple text fields into a single string. Simply input the different text values – these can be literal copyright or references to cells containing further text – and the function will put together them.