I get a "Webpage cannot be found" error page when I click either this link or the link in the previous message.Here is a link to a screenshot showing the sheet and notes:
https://www.purekarting.com/assets/woo_varient_trim.png
Since you already appear to have formula in place, just change the delimiter from the pipe symbol to a space, wrap that result with a TRIM function call to eliminate the multiple spaces and then wrap that results with a SUBSTITUTE function call that changes the space to a pipe symbol.Sorry about that. My new webserver won't allow direct linking to files. Let's try these links:
Image
https://drive.google.com/open?id=0B3CdLSpqBchoTVAxdlVPM0doaGM&authuser=0
Excel file
https://drive.google.com/open?id=0B3CdLSpqBchoelVWTTFwZ2w5MkU&authuser=0
Since you already appear to have formula in place, just change the delimiter from the pipe symbol to a space, wrap that result with a TRIM function call to eliminate the multiple spaces and then wrap that results with a SUBSTITUTE function call that changes the space to a pipe symbol.
=SUBSTITUTE(TRIM(SUBSTITUTE(aconcat(IF($F$2:$F$5000=$G2," "&H$2:H$5000,""))," ","",1))," ","|")