![]() If you want to delimit the input range with a comma just use concat(a1:a7,",") to get the out of a,b,c,d,e,f,g Just download the concat() UDF excel add-in and double click on it to install it. Its nothing miraculous or anything, it just does the dirty job of going through the range for you. Instead, you can use concat(a1:a7) by installing the UDF (User defined function) I have written. ![]() What more you can use this to delimit the input range with your own favorite character.įor example, if each of the 7 cells in a1:a7 have “a”, “b”, “c”, “d”, “e”, “f”, “g”, if you want to add all of them up using concatenate you would have to write concatenate(a1,a2,a3,a4,a5,a6,a7) which can be painful if you are planning to do this over a large range or something. I felt bored enough the other day to write a better concatenate(), one that can accept a range as input and output one text with all the contents of the input range. This means, when you have a range of cells with text which you want to add up to create a large text, you need to write an ugly looking biggish concatenate() or use ‘&’ operator over and again. Excel concatenate() is seriously crippled, it can add 2 or more strings together, as long as they are supplied as separate parameters.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |