![]() ![]() Use INDIRECT if you want the worksheet name to be a text string chosen by the user. The single quotes around the worksheet name are only necessary if the worksheet name includes a space. The example below shows a reference to cell A5 in worksheet 'Sheet 2'. 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 |