Forum Discussion
NoahRaymond
Jan 05, 2021Copper Contributor
Help with Excel / Word and macros
I am looking for help with a few different tasks. I sell sports cards on eBay and they have a quick file upload in a spreadsheet format. When I list cards though there could be as many as 800 variatio...
Viz
Jan 05, 2021Brass Contributor
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," ",";")