CONCATENATE Function - Microsoft Excel Tips & Tricks

Although I am writing this from SEM point of view where trainees often face problem while maintaining and editing work reports and voluminous database, this Microsoft Excel tip comes handy to professionals from all walk of life.

Joining two strings together often baffles beginners in Excel. One of the handy function to solve this problem is using formula CONCATENATE.

One of the problems I have often come across is joining 2 strings. In layman term it's joining Cell A1 and Cell B1 to Get resultant Cell C1 as A1B1 e.g. if

A1 is http://www.

and

B1 is example.com

then using C1 =CONCATENATE (A1,B1) function will return

C1 as http://www.example.com

The CONCATENATE function could be used to join together multiple words and phrase to form one complete sentence.

All you have to do is select the cell where you want the result and click on formula bar or just write in the formula bar CONCATENATE(A1,B1) and select the cells where you want to add up the two strings and bingo!

So what do you do when you have say 1000 websites and you want to add http://www. in the beginning of all cells.

Try out the CONCATENATE function today...remember the adage "practice makes perfect".

N.B. You can also use the ampersand (&) instead of the CONCATENATE for example, =A1&B1 returns the same value as =CONCATENATE(A1,B1)