lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have numbers in one column as below, i want them in one cell if possible as following
10,20,30,40,50,60 OR 10, 20, 30, 40, 50, 60 (space after comma)
I am thinking to use copy-->paste special--> transpo, then user concatenate() function to join them with "," between them. Is that the best solution? Thank you so much
<tbody>
</tbody>
I have numbers in one column as below, i want them in one cell if possible as following
10,20,30,40,50,60 OR 10, 20, 30, 40, 50, 60 (space after comma)
I am thinking to use copy-->paste special--> transpo, then user concatenate() function to join them with "," between them. Is that the best solution? Thank you so much
10 |
20 |
30 |
40 |
50 |
60 |
<tbody>
</tbody>
Last edited: