![]() VLOOKUP: It looks up for a value in a column and can return that value or a value from the corresponding columns using the same row number.You need to specify the text and number of characters to extract. RIGHT: It extracts specific characters from a string starting from the right (last).LEFT: It extracts specific characters from a cell/string starting from the left (start).DATE: It returns a valid date (date serial number) as per Excel’s time format by using the day, month, and year specified.You need to specify hours, minutes, and seconds. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |