Select the cell where you want the merged text to appear. From within the chosen cell, please type the following formula, then hit the Enter key: Replace the Mr. section with the text you want to ...