Strip empty space (Office XP)

Hi,

I am using an append query to merge the data from two fields [suburb] and [city] into one field called [suburb/city]. This is working really well, thanks to a tip from the lounge last week. I have noticed however, that if there is data in the city field but not the suburb field then there is a space to the left of the data. The instruction i am using in the append query is =[maindataentry]!suburb&" "&[maindataentryentry]!city. I can see where the space is coming from, is there an easy way I can run another update query and strip it out?