SELECTED USEFUL EXCEL FORMULAS FORMULA DESCRIPTION SYNTAX Casing …

Short Description
SELECTED USEFUL EXCEL FORMULAS. FORMULA. DESCRIPTION. SYNTAX. Casing Functions. PROPER. change text string to proper casing. =PROPER(text or cell reference) …

Website: www.wallst-training.com | Filesize: 5kb

Content
SELECTED USEFUL EXCEL FORMULAS
FORMULA DESCRIPTION SYNTAX
Casing Functions
PROPER change text string to proper casing =PROPER(text or cell reference)
UPPER change text string to upper casing =UPPER(text or cell reference)
LOWER change text string to lower casing =LOWER(text or cell reference)
String Manipulation
& concatenate text and cells together =A1&”text”&A2
LEFT return N # of characters from the left =LEFT(text,num_chars)
RIGHT return N # of characters from the right =RIGHT(text,num_chars)
FIND find the first specified character in a text string =FIND(find_text,within_text,start_num)
INDIRECT returns reference specified by a text string =INDIRECT(ref_text)
DATEVALUE converts a date to corresponding number =DATEVALUE(date_text)
Lookup Functions
VLOOKUP looks for a value in Nth column of a vertical array of data =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
HLOOKUP looks for a value in Nth row of a horizontal array of data =HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
MATCH returns relative position of a value in an array =MATCH(lookup_value,lookup_array,match_type)
Switches…