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 :$=$LEFT$($A$2,$FIND$("",$A$2)-1)$&$"$@supplier.org", but result is: G@supplier.org, Which only show the first letter. I need to get the correct output: globalgoods@supplier.org

$\backslash$table$[[$A$,$B$,$C$,$D$,$E$],[$Supplier Name,Supplier Address,State,City,Contact Email$],[$GlobalGoods Distributors,$634$ Cedar Street Blvd $//$Charleston$,$ WV$,$WV$,/$Charleston$,$G@supplier.org$],[$EcoHarbor Suppliers,$2781$ Oak Avenue Rd $/$ Richmond, VA$,$VA$,$Richmond,E@supplier.org$],[$SummitSource Trading Co$.,179$ Pine Boulevard Ln $/$ Raleigh, NC$,$NC$,$Raleigh,S@supplier.org$],[$PrimeTech Solutions,$4862$ Pine Street Blvd$/$Myrtle Beach, SC$,$SC$,$Myrtle Beach,P@supplier.org$],[$Harmony Imports,$239$ Oak Avenue Ln $/$Memphis$,$ TN$,$TN$,$Memphis,H@supplier.org$],[$Apex Merchandise Group,$483$ Cedar Boulevard Rd $/$Charleston$,$ W$,$WV$,$Charleston,A@supplier.org$],[$StarCrest Trading,$5417$ Oak Street Blvd $/$ Baltimore, MD$,$MD$,$Baltimore,S@supplier.org$],[$NatureWares Distributors,$742$ Pine Boulevard Ave $/$ Greenville, SC$,$SC$,$Greenville,N@supplier.org$],[$Quantum Resources Intl.,$4029$ Oak Boulevard Ave $/$ Charlotte, NC$,$NC$,$Charlotte,Q@supplier.org$],[$EliteCraft Suppliers,$278$ Cedar Avenue Blvd $/$Parkersburg$,$ W$,$WV$,$Parkersburg,E@supplier.org$],[$Pinnacle Trading Partners,$543$ Pine Street Rd$/$Arlington$,$ VA$,$VA$,$Arlington,P@supplier.org$],[$EcoFusion Enterprises,$724$ Cedar Street Ave $/$Charleston$,$ WV$,$WV$,$Charleston,E@supplier.org$],[$RegalVista Imports,$1426$ Pine Avenue Ln $/$ Greenville, SC$,$SC$,$Greenville,R@supplier.org$],[$SummitPrime Logistics,$579$ Maple Street Rd$/$Annapolis$,$ MD$,$MD$,$Annapolis,S@supplier.org$],[$HorizonGoods Trading,$123$ Palm Avenue Blvd$/$Nashville$,$ TN$,$TN$,$Nashville,H@supplier.org$],[$TerraVista Suppliers,$5938$ Cedar Boulevard Ln $/$ Raleigh, NC$,$NC$,$Raleigh,T@supplier.org$],[$QuantumQuest Distributors,$916$ Cedar Boulevard Rd$/$Knoxville$,$ TN$,$TN$,$Knoxville,Q@supplier.org$],[$GlobalHarbor Trading CO$.,3271$ Oak Street Blvd $/$ Richmond, VA$,$VA$,$Richmond,G@supplier.org$],[$Elemental Imports Hub,$598$ Oak Boulevard Ave $/$Myrtle Beach, $1,$SC$,$Myrtle Beach,E@supplier.org$],[$Vista Craft Merchandise,$7395$ Palm Street Blvd$/$Morgantown$,$ W$,$WV$,$Morgantown,V@supplier.org$]]$