Forum Discussion
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...
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," ",";")