How to add same prefix at the end of each cell in excel.

                    

People dealing with the databases in excel might have some time faced a situation to postfix some content at the end of each cell in a row or in a column or in all the cells. One most common example is the inclusion of email extension like @gmail.com or @ somedomain.com etc. at the end of some group of cells. For that one can directly follow a procedure which excel allows us to do. For say you have collected a certain database through a google document, the database might consist of gmail id's of all the responses, but when you are planning to send a bulk mail to all those applied participants, normally people who does not know this technique will copy "@gmail.com" and paste it at the end of each cell in the concerned column. Rather than doing that, one can adopt the following technique.

• Click on an empty cell which is in the same row consisting of the first email id.
• Go to the function bar. For example if the above is the case.

• In the function bar, type the value of the new cell is equal to the old cell & "gmail.com". For our case F2 = D2&"@gmail.com"

•  Then later drag the new cell along the column to make the change effect in all the corresponding cells.

This is how one can use excel to manipulate the databases and make the things more useful for us.