CONCATENATE is a function used to join text in one cell to another. You can find ‘concatenate‘ in paste function dialog box.
Click the ‘Paste Function’ icon in standard tool bar to open function dialog box. Select concatenate function from Text category.
A formula wizard appears in your screen that assists you in building the formula properly. You can drag it in case it covers your working area. Using mouse select the cells from which you want to join text. You can select several cells to form a long chain.
Tip: Use Shift and F3 keys at the same time to open Paste function dialog box.
If you want to type directly the formula please go through the following examples.
=CONCATENATE(G17,G18)
This formula simply joins text in the two cells G17 and G18
=CONCATENATE(G17," ",G18)
This formula joins text in the two cells G17 and G18 with a gap in between.
=CONCATENATE(G18," April’ 05")
This appends text ‘April’ 05’ with the value in G18.
Tips: You can even join texts that are in different cells using a simple method. Go through the previous examples using this easy way.
It joins text in the two cells G17 and G18
=G17&" "&G18
It joins text in two cells G17 and G18 with space in between.
=G18&" April' 05"
It appends text April’ 05 with the value in G18
Try yourself and simply your day to day task. This function is very easy to use.