microsoft office excel
, , , , , , ,

How to quickly Concatenate Columns data in Office Excel

In your Excel workbooks, the data is not always structured according to your needs. Often you may want to split the content of one cell into individual cells, or do the opposite - combine data from two or more columns into a single column. Common…
Microsoft Office - kamiltech
, , ,

How To: Use HLOOKUP Function in Office Excel

HLOOKUP function in Excel is a sibling of VLOOKUP function. The H in the HLOOKUP stands for “Horizontal” and hence it is often called as Horizontal Lookup.HLOOKUP is a very useful function for creating horizontal lookups, but as most…