Hi Mr. Guy,
The answer is see columns "G" of following.
<CENTER><TABLE ALIGN=CENTER BORDER=1><TR><TD BGCOLOR=#0C266B COLSPAN=8><FONT COLOR=WHITE>Microsoft Excel - Trim function.xls</FONT></TD></TR><TR><TD BGCOLOR=#D4D0C8 COLSPAN=8>File(<U>F</U>) Edit(<U>E</U>) View(<U>V</U>) Insert(<U>I</U>) Tool(<U>T</U>) Data(<U>D</U>) Window(<U>W</U>) Help(<U>H</U>)</TD></TR><TR><TD ALIGN=CENTER COLSPAN=2 BGCOLOR=White>G4</TD><TD ALIGN=CENTER BGCOLOR=#D4D0C8>=</TD><TD COLSPAN=5 BGCOLOR=White>=SUBSTITUTE(F4," ","")</TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER> </TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>A</TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>B</TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>C</TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>D</TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>E</TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>F</TD><TD BGCOLOR=#D4D0C8 ALIGN=CENTER>G</TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>1</TD><TD BGCOLOR=White> </TD><TD BGCOLOR=White> </TD><TD BGCOLOR=White> </TD><TD BGCOLOR=White> </TD><TD BGCOLOR=White> </TD><TD BGCOLOR=White> </TD><TD BGCOLOR=White>Answer is</TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>2</TD><TD BGCOLOR=White>101</TD><TD BGCOLOR=White>-</TD><TD BGCOLOR=White>P T </TD><TD BGCOLOR=White>-</TD><TD BGCOLOR=White>200</TD><TD BGCOLOR=White>=CONCATENATE(A2,B2,C2,D2,E2)</TD><TD BGCOLOR=White>=SUBSTITUTE(F2," ","")</TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>3</TD><TD BGCOLOR=White>102</TD><TD BGCOLOR=White>-</TD><TD BGCOLOR=White>L T</TD><TD BGCOLOR=White>-</TD><TD BGCOLOR=White>201</TD><TD BGCOLOR=White>=CONCATENATE(A3,B3,C3,D3,E3)</TD><TD BGCOLOR=White>=SUBSTITUTE(F3," ","")</TD></TR><TR><TD WIDTH=5 BGCOLOR=#D4D0C8 ALIGN=CENTER>4</TD><TD BGCOLOR=White>103</TD><TD BGCOLOR=White>-</TD><TD BGCOLOR=White>MOV</TD><TD BGCOLOR=White>-</TD><TD BGCOLOR=White>202</TD><TD BGCOLOR=White>=CONCATENATE(A4,B4,C4,D4,E4)</TD><TD BGCOLOR=White>=SUBSTITUTE(F4," ","")</TD></TR></TABLE></CENTER>