Tag Archives: Excel

Custom Views in Excel

http://chandoo.org/wp/2008/12/17/custom-views-excel/ The Problem: You have created a specific view of your data in Excel (say by filtering, zooming out, changing column width, hiding specific rows, customizing window settings, print settings etc.). This is your reference point say view ABC. Then, … Continue reading

Posted in Technology, Tools | Tagged | 1 Comment

Excel Concatenate

A very useful little command for joining multiple values together into one cell output =CONCATENATE(A1,B1,C1) If you want spaces in between =CONCATENATE(A1,” “,B1,” “,C1) or underscores “_” If you would rather have them on separate rows in one cell =CONCATENATE(A1,CHAR(10),B1,CHAR(10),C1)

Posted in Brain Dump, Tools | Tagged , | 2 Comments