Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Converting an array of number into a string

380 1
Showing results for 
Search instead for 
Did you mean: 

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:

How can I get 123456 432567 5676328 ?

1 Reply 1

Found it :winking_face:

ARRAYJOIN({Person ID}," ")