Dear Admin,
I got a coding as below, it is work fine but I crack my head also can't think of how to amend it to suit my need. My coding work as example below,
Example:
Initial in A1:A
Row 1 100
Row 2 200
Row 3 300
Row 4 400
Row 5 500
Result:
Col1 Col2 Col3 Col4 Col5
100 200 300 400 500
However, I wish to add comma sign can convert it into one single cell. Is It possible ?
Result is
100,200,300,400,500
Even though I canno't convert all in one cell can 255 character limitatiton, at least I can make it auto add comma sign for me , any idea??? Thanks in advance .
Bookmarks