Project numbers were previously typed in a colum with either one or two blank spaces (i.e. P - 000-934-042). There should not be any blank spaces. I am trying to remove these blank spaces without having to retype so many numbers. The database contains about 3500 entries with about 400 typed in this incorrect format. I know there's a formula in Excel that can remove blank spaces within a column, but I don't know about Access.