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 combine character strings from several cells 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. The concatenate function can make that a simple task if you need those digits strung together with a dash between them in one field.
Excel Concatenate, we love this feature! Use this feature if you have information in two separate cells that need to be merged. Follow this example formula in a new cell, =Concatenate(A1, “”, B1). Once you have all the cells you wish to combine listed, hit the tab, and you are done! You can drag the fill handle to copy the formula to other cells.
Important: In Excel, 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!
Cool Tools – Excel Concatenate
ZümiFi’s ongoing bookkeeping services manage your financial activity with a complete turnkey approach. We deliver solid books that provide you with key information in real-time, accessible anywhere, anytime, on any device.
We create a custom combination of online, cloud-based tools, including QuickBooks Online, Bill.com, Box.com, and other tools in unique combinations to truly leverage technology. This enables us to fully automate your system, eliminate data entry, and simplify and facilitate your bookkeeping. And we ensure accuracy and completeness so that every dollar counts.
The Scope of ZümiFi’s Bookkeeping Services:
Accounts Payable Services – Recording, tracking, and paying vendor bills.
Accounts Receivable Services – Recording and tracking customer invoices and payments.
Payroll Services – Processing payroll per each client’s instructions regarding amounts to pay; processing and filing appropriate payroll taxes and tax forms.
Reconciliations – Reviewing and balancing bank and credit card transactions; notifying the client of any discrepancies and resolving discrepancies per the client’s instructions when appropriate.
They are reporting – Generating financial reports based on the collected data.