It's time to duplicate this formula in the remaining column's cells. Type the argument as the text you want to add in inverted commas (“”) and choose the cell you wish to add after it.Ĥ. Type “=con” in the target cell and choose if you want to use the CONCAT or the CONCATENATE function. Here, I will show you an example of adding “Dr.” to the beginning of a list of names.ġ. The CONCAT and CONCATENATE FunctionĬONCAT AND CONCATENATE function are very helpful if you wish to add a certain title in the beginning or end of a list. Information provided in this article are compatible with versions 2010/2016/MAC/online. For example, if you have a list of addresses and you want to include each address with its corresponding city name, then adding Address or City to the beginning of all cells will be useful. In some cases, you may need to add text to the beginning of all cells in Excel. This is not just for aesthetic purposes-it's also important because it will help you keep track of what the data means.
In order to make sure that the data in your Excel file is organized in a way that makes sense, you will want to add some text to the beginning or end of all cells.
0 kommentar(er)
