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

I

In a dilemna

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.
 
O

Ofer

Try and use the replace function to replace space with empty

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