Cleaning up spreadsheets might not be in your job description, but it’s a common task for most financial managers. Use Excel’s handy concatenate function to optimize databases by joining character strings in destination cells.
Excel’s concatenate function is designed to join character strings from several cells together in another destination cell. For example, you might have a database of U.S. addresses with the first five digits of the ZIP code in one field and the other four digits in another. If you need those digits strung together with a dash between them in one field, the concatenate function can make that a simple task.
Excel Concatenate, we love this feature! If you have information in two separate cells that need to be merged – use this feature. Follow this example formula in a new cell, =Concatenate(A1, “ “, B1). Once you have all the cells you wish to combine listed, hit tab and you are done! You can drag the fill handle to copy the formula to other cells.
Important: In Excel 2016, Excel Mobile, and Excel Online, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.
ZümiFi – securing bookkeeping every chance we get!