Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a contact email for each Supplier = First word in Supplier's name @supplier.org please use the excel and excel function i used the function
Create a contact email for each Supplier First word in Supplier's name @supplier.org
please use the excel and excel function
i used the function :LEFTAFINDA&@supplier.org", but result is: G@supplier.org, Which only show the first letter. I need to get the correct output: globalgoods@supplier.org
tableABCDESupplier Name,Supplier Address,State,City,Contact EmailGlobalGoods Distributors, Cedar Street Blvd Charleston WVWVCharlestonG@supplier.orgEcoHarbor Suppliers, Oak Avenue Rd Richmond, VAVARichmond,E@supplier.orgSummitSource Trading Co Pine Boulevard Ln Raleigh, NCNCRaleigh,S@supplier.orgPrimeTech Solutions, Pine Street BlvdMyrtle Beach, SCSCMyrtle Beach,P@supplier.orgHarmony Imports, Oak Avenue Ln Memphis TNTNMemphis,H@supplier.orgApex Merchandise Group, Cedar Boulevard Rd Charleston WWVCharleston,A@supplier.orgStarCrest Trading, Oak Street Blvd Baltimore, MDMDBaltimore,S@supplier.orgNatureWares Distributors, Pine Boulevard Ave Greenville, SCSCGreenville,N@supplier.orgQuantum Resources Intl., Oak Boulevard Ave Charlotte, NCNCCharlotte,Q@supplier.orgEliteCraft Suppliers, Cedar Avenue Blvd Parkersburg WWVParkersburg,E@supplier.orgPinnacle Trading Partners, Pine Street RdArlington VAVAArlington,P@supplier.orgEcoFusion Enterprises, Cedar Street Ave Charleston WVWVCharleston,E@supplier.orgRegalVista Imports, Pine Avenue Ln Greenville, SCSCGreenville,R@supplier.orgSummitPrime Logistics, Maple Street RdAnnapolis MDMDAnnapolis,S@supplier.orgHorizonGoods Trading, Palm Avenue BlvdNashville TNTNNashville,H@supplier.orgTerraVista Suppliers, Cedar Boulevard Ln Raleigh, NCNCRaleigh,T@supplier.orgQuantumQuest Distributors, Cedar Boulevard RdKnoxville TNTNKnoxville,Q@supplier.orgGlobalHarbor Trading CO Oak Street Blvd Richmond, VAVARichmond,G@supplier.orgElemental Imports Hub, Oak Boulevard Ave Myrtle Beach, SCMyrtle Beach,E@supplier.orgVista Craft Merchandise, Palm Street BlvdMorgantown WWVMorgantown,V@supplier.org
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started