Himself wrote: > Trying the TRIM option within Excel didn't but I must have got the syntax > wrong as it just gave #VALUE, at which point I didn't understand. Well, I gather you've already fixed it, but here's yet another method: 1. Select the column to be fixed 2. Insert column 3. In the new column, next to the first cell to be fixed, put =Trim(B1) if you are fixing column B and the first bad cell is row 1 if not, adjust. 4. Select from the =trim to the bottom. 5. Fill down 6. Select it again (probably still is) 7. Edit -> Paste special -> click "Values" -> OK 8. Your new column is now the "fixed" version of the old. Delete the old. -- Wes Groleau Guidelines for judging others: 1. Don't attribute to malice that which can be adequately explained by stupidity. 2. Don't attribute to stupidity that which can be adequately explained by ignorance. 3. Don't attribute to ignorance that which can be adequately explained by misunderstanding.