How to remove blank spaces between numbers & letters in a column

[Guest]

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.

 

[SusanV]

You can use the Replace function to do this.

 

[Guest]

Try and use the replace function to replace space with empty

Select Replace(FieldName," ","") As NewName From TableName