string move from down cell to up beside exiting cell sting without change

[AT BABU]

Hi All

string move from down cell to up beside exiting cell sting without change

[TABLE="width: 129"]
<colgroup><col></colgroup><tbody>[TR]
[TD]23624718,[/TD]
[/TR]
[TR]
[TD]23624719,[/TD]
[/TR]
[TR]
[TD]23624720,[/TD]
[/TR]
[TR]
[TD]23624721,[/TD]
[/TR]
[TR]
[TD]23624722,

I need like thsi [/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 409"]
<tbody>[TR]
[TD="class: xl65, width: 409"]23624718,23624719,23624720,23624721,23624722

Thank you All[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Excel 2016 contain both TEXTJOIN and CONCAT.
Are you sure that is the version you are on?
Is it Windows or Mac based?

Also, what is the default function argument delimiter? Or some non-American versions, it may be set to a semi-colon rather than a comma, so you would need to use:

=TEXTJOIN("";TRUE;A1:A5)

 

[Peter_SSs]

Excel 2016 contain both TEXTJOIN and CONCAT.

Sorry to contradict Joe but actually Excel 2016 stand-alone (standard as described by the OP) does not include TEXTJOIN or CONCAT - I previously had that version. You need to have Office 365 or Excel 2019. Ref: https://support.office.com/en-us/article/concat-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2

 

[Joe4]

Sorry to contradict Joe but actually Excel 2016 stand-alone (standard as described by the OP) does not include TEXTJOIN or CONCAT - I previously had that version. You need to have Office 365 or Excel 2019. Ref: https://support.office.com/en-us/art...6-694cbd6b4ca2

No need to apologize, I was mistaken. I have it at work, and I thought we had Excel 2016 (but it looks like we actually have 365).
Thanks for the correction.

 

[Joe4]

AT BABU,

So you may need to do something like:

=A1 & A2 & A3 & A4 & A5

or

=CONCATENATE(A1,A2,A3,A4,A5)

 

[AT BABU]

Working
Thank you

 

[Joe4]

You are welcome.