Add text

 UDF for adding a specific text

Here we want to create a function that can add a specific text along with the text mentioned in another cell.

For example - I want to add a text called ".gmail.com" to a cell where "smartexcel" is written in a separate cell through a formula.

We will create a function called "Addtext" for this.

Function Addtext(x) y = ".gmail.com" Addtext = x & y End Function