Converting an array of number into a string

In one cell, I can select students located in another tab. If I select 1 student, I look up also the person ID which is a number : 123456.

If I select 3 students, the lookup function will show 3 person ID as below:
123456, 432567, 5676328

I need to show those values without the comma.

I use a formula: SUBSTITUTE({Person ID},‘,’,’ ') but it generates an error, I believe because the students ID are not a text string but an array

When converting the array in string, using the formula SUBSTITUTE({Person ID}& “”,‘,’,’ ') I get this result:
1234564325675676328

How can I get 123456 432567 5676328 ?

Found it :wink:

ARRAYJOIN({Person ID}," ")

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.