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 ?
