Learn Microsoft Excel Online FreeThis post explains that how to convert a column number to a column letter using formula in excel. How to convert column number to a column letter using user defined function in VBA. Convert column number to letter using excel formula if you want to convert column number to letter, you can use the ADDRESS… read more »
This post will guide you how to use Excel ADDRESS function with syntax and examples in Microsoft excel. Description The Excel ADDRESS function returns a reference as a text string to a single cell. The ADDRESS function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The ADDRESS function… read more »
This section will learn how to use Excel’s Lookup And Reference Functions such as: Address, Areas, Columns, Hlookup, Vlookup, Lookup, Index, Match, etc. ADDRESS – returns a reference as a text string to a single cell. AREAS – returns the number of ranges in a reference. CHOOSE – returns a value from a list of values. COLUMN – returns… read more »
