Hi Guys,


I am running into a small problem were a bunch of lookup tables have multiple fields with values containing spaces at the end of the values. What I would want is to create a macro that looks at all the tables that start with the word "Loopkup" goes into every column for these tables and trims all the values so it gets rid of the spaces.

Anyone has any idea how I would go about building something like this.

Many thanks!


Robert