Help with Excel / Word and macros

%3CLINGO-SUB%20id%3D%22lingo-sub-2035050%22%20slang%3D%22en-US%22%3EHelp%20with%20Excel%20%2F%20Word%20and%20macros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2035050%22%20slang%3D%22en-US%22%3EI%20am%20looking%20for%20help%20with%20a%20few%20different%20tasks.%20I%20sell%20sports%20cards%20on%20eBay%20and%20they%20have%20a%20quick%20file%20upload%20in%20a%20spreadsheet%20format.%20When%20I%20list%20cards%20though%20there%20could%20be%20as%20many%20as%20800%20variations.%20I%20can%20download%20a%20spreadsheet%20with%20the%20info%20I%20need%20but%20each%20variation%20has%20to%20be%20separated%20with%20a%20semi%20colon.%20Is%20there%20a%20way%20to%20use%20macros%20to%20do%20this.%20Second%20issue%20is%20inputting%20picture%20locations%20into%20the%20spreadsheet.%20I%20was%20told%20you%20can%20use%20macros%20to%20do%20this%20task%20also.%20It%20would%20be%20800%20different%20images%20into%20800%20different%20lines%20on%20the%20spreadsheet.%20Any%20help%20would%20be%20appreciated.%20Thank%20you!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2035050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2035089%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Excel%20%2F%20Word%20and%20macros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2035089%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F919312%22%20target%3D%22_blank%22%3E%40NoahRaymond%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20share%20how%20the%20input%20would%20look%20like%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20going%20to%20have%20the%20card%20info%20in%20a%20set%20of%20rows%20or%20columns%20and%20if%20all%20you%20need%20is%20one%20single%20text%20of%20all%20of%20them%20with%20semicolons%20in%20between%2C%20then%20you%20can%20use%20the%20TextJoin%20function%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DTextJoin(%22%3B%22%2C%2C%5BYour%20Range%5D)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternatively%2C%20if%20you%20are%20already%20have%20them%20as%20a%20continous%20text%20with%20space%20in%20between%20and%20you%20need%20to%20replace%20the%20space%20with%20semicolon%20then%20you%20can%20either%20use%20find%20%2F%20replace%20command%20or%20use%20substitute%20function%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSubstitute(YourText%2C%22%20%22%2C%22%3B%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
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 variations. I can download a spreadsheet with the info I need but each variation has to be separated with a semi colon. Is there a way to use macros to do this. Second issue is inputting picture locations into the spreadsheet. I was told you can use macros to do this task also. It would be 800 different images into 800 different lines on the spreadsheet. Any help would be appreciated. Thank you!
1 Reply

@NoahRaymond 

 

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