Removing unintentional spaces when assembly multiple texts based on IF's

[helloworld_2022]

Hi everyone,

I want to remove any unintentional spacings in my formula, when visible in the cell.
The formula is af following:

=A82&" "&'Work Order (Client)'!D46&" "& "on commission (pre-payment)"&""&IF('Input sheet'!B31="Proteomics";",";"")&""&IF('Input sheet'!B31="Proteomics";G113;"")&""&IF('Input sheet'!C31="Metabolomics";",";"")&" "&IF('Input sheet'!C31="Metabolomics";G114;"")&""&IF('Input sheet'!E31="Transcriptomics";",";"")&"  "&IF('Input sheet'!E31="Transcriptomics";G115;"")&""&IF('Input sheet'!G31="Laser-microdissection";",";"")&" "&IF('Input sheet'!G31="Laser-microdissection";G116;"")&""&"."

You can find the result attached as an image. The issue is, let's say that I don't have WP Proteomics and WP Metabolomics; there is a spacing between the commas and the previous sentence, and the more IF's that exclude a text, the more spacing (see the other attachment). I could just put in a comma after each sentence, but then it will not necessarily end with a dot if it's the last IF selected in the sequence.

I'm looking forward to hearing your suggestions.

Kindly,
Louis

 

[helloworld_2022]

I've tried to use Text Trim, but it only removed one of the two spacings (where it double-spaces).