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

23624718,

23624719,

23624720,

23624721,

23624722, I need like thsi

<colgroup><col></colgroup><tbody>
</tbody>

23624718,23624719,23624720,23624721,23624722 Thank you All

<tbody>
</tbody>

 

[Joe4]

In your example, are those 5 numbers all in one cell, or in multiple cells?

 

[AT BABU]

In your example, are those 5 numbers all in one cell, or in multiple cells?

multiple cells

 

[Joe4]

If you are using Excel 2016 or newer, you can use the TEXTJOIN function.
So, if your entries are in cells A1:A5, try:

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

 

[AT BABU]

If you are using Excel 2016 or newer, you can use the TEXTJOIN function.
So, if your entries are in cells A1:A5, try:

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

Tahnk you

 

[Peter_SSs]

If they already have the commas, as assumed by Joe's formula, then you could also use the even simpler

=CONCAT(A1:A5)

Note that both suggestions leave a comma on the right end of the result if the cell values have that trailing comma. Is that an issue for you?

If so, try
=LEFT(CONCAT(A1:A5),LEN(CONCAT(A1:A5))-1)

 

[Joe4]

You are welcome.
Glad we could help.

 

[AT BABU]

Not Working in My Excle (Microsoft office standard 2016)

 

[Joe4]

Which one is not working (you have two solutions)?

Please tell us what is happening.
Are you getting errors (if so, what do they say), or are you getting unexpected results (if so, what are they)?

 

[AT BABU]

both

Error #Name ?