![]() ![]() ![]() Say that you removed Charlie from cell A4. This will prevent two consecutive delimiters from appearing. In the second argument, you can specify that empty values should be ignored.For example, including “, ” would make sure that the names appear with a comma and space between them: Andy, Betty, Charlie, Dale, Eddy. The first argument lets you specify a delimiter to appear between each value. ![]() The syntax of TEXTJOIN is =TEXTJOIN(Delimiter, Ignore_Empty, Text1, ,…). TEXTJOIN offers some improvements over CONCATENATE. ![]() Unless the values stored in column A happened to have trailing spaces, you would end up with a hard-to-read result like AndyBett圜harlieDaleEddy. Instead, you had to specify each cell individually: =CONCATENATE(A1,A2,A3,A4,A5,…A26). In the past, if you wanted to concatenate a list of names in column A, you couldn’t use a simple formula such as =CONCATENATE(A1:A26). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |