Help

Converting an array of number into a string

1687 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Pascal_Vallet
6 - Interface Innovator
6 - Interface Innovator

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 ?

1 Reply 1
Pascal_Vallet
6 - Interface Innovator
6 - Interface Innovator

Found it :winking_face:

ARRAYJOIN({Person ID}," ")