The INDIRECT function allows you to create a reference from a text string. ![]() Use INDIRECT to create a reference from a text string The TEXTJOIN function lets you specify a delimiter and ignore blank values. The CONCAT function is like CONCATENATE except that it lets you use a range of cells as an argument. The CONCAT and TEXTJOIN functions are new functions that requires an Office 365 subscription (they work in Excel Online). ![]() ![]() NOTE The spaces before and after the & operator are not required - I've included the spaces only to help make the formula more readable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |