Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
In Office 365 and Excel 2019 there is a TEXTJOIN: =TEXTJOIN(",",,A1:A10) which can be written into the cell where the output is required. Assumes A1:A10 has been populated to suit.
Answer
#5: Post undeleted
by
Alexei
·
2021-05-26T18:05:53Z (over 3 years ago)
#4: Post deleted
by
pnuts
·
2021-05-24T06:37:37Z (over 3 years ago)
#3: Post edited
by
pnuts
·
2020-08-13T19:40:13Z (over 4 years ago)
- In Office 365 and Excel 2019 there is a [TEXTJOIN](https://exceljet.net/excel-functions/excel-textjoin-function):
- =TEXTJOIN(",",,A1:A10)
which can be written into the cell where the output is required.
- In Office 365 and Excel 2019 there is a [TEXTJOIN](https://exceljet.net/excel-functions/excel-textjoin-function):
- =TEXTJOIN(",",,A1:A10)
- which can be written into the cell where the output is required.
- Assumes A1:A10 has been populated to suit.
#2: Post edited
by
pnuts
·
2020-08-13T19:36:26Z (over 4 years ago)
- In Office 365 and Excel 2019 there is a [TEXTJOIN](https://exceljet.net/excel-functions/excel-textjoin-function):
- =TEXTJOIN(",",,A1:A10)
which can be written into the cell where the output is required. Copy & Paste (without Paste Special, Values) say `=$B9&","&A10` anywhere but B10 will automatically adjust cell references so is not guaranteed to give the same result as shown in B10 by inference in https://software.codidact.com/questions/277259#answer-277261.
- In Office 365 and Excel 2019 there is a [TEXTJOIN](https://exceljet.net/excel-functions/excel-textjoin-function):
- =TEXTJOIN(",",,A1:A10)
- which can be written into the cell where the output is required.
#1: Initial revision
by
pnuts
·
2020-08-13T19:34:09Z (over 4 years ago)
In Office 365 and Excel 2019 there is a [TEXTJOIN](https://exceljet.net/excel-functions/excel-textjoin-function):
=TEXTJOIN(",",,A1:A10)
which can be written into the cell where the output is required. Copy & Paste (without Paste Special, Values) say `=$B9&","&A10` anywhere but B10 will automatically adjust cell references so is not guaranteed to give the same result as shown in B10 by inference in https://software.codidact.com/questions/277259#answer-277261.