combining text when it has space

[Jazzy007]

Hi

is it possible to combine text in a table when some have a space between them eg 123 456 789B would like it on the table as 123456789B without any space. I was not sure what command to use in a query to get this type of and use it for an update query if possible.
Can someone help
Many thanks

 

[MStef]

Look at "DemoSpaceA2000.mdb".
Look at Table1, Qurey1Update.
run Query1Update, look at Table1.
It works if all fields "f2" is 10 byte long.