Jan 05 2021 08:35 PM
Jan 05 2021 09:12 PM
Can you share how the input would look like?
If you are going to have the card info in a set of rows or columns and if all you need is one single text of all of them with semicolons in between, then you can use the TextJoin function
=TextJoin(";",,[Your Range])
Alternatively, if you are already have them as a continous text with space in between and you need to replace the space with semicolon then you can either use find / replace command or use substitute function
=Substitute(YourText," ",";")