Tag Archives: Justify

Feel justified with Fill Justify

Like majority of smartphone users, Excel users (know how to) use only a little portion of functionalities provided by the tool, even though we pay the full price for the tool… Fill Justify (on the editing group of the Home Tab) is … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment

Combine contents in a range of cells into a single cell, with no VBA nor formula.

  Well, the first thing in your mind maybe using ampersand &  or CONCATENATE to combine them. =A1&” “&A2&” “&A3&” “…… =CONCATENATE(A1,” “,A2,” “……) which is more or less time consuming. Two ways to achieve this quickly Using a combination of … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments