Clean Data in a Feild

[julialatte]

I get data in that I have work with that comes in a string in a single field
called Field1 that looks like like this:

203948sdf, 4,3,3, ysdifwier werioweir ** sdlfkwier jsdfj, fjdj

How can I remove all of the characters, the commas the asterisks all of it,
and also make sure there is just one space between each item so when I'm done
it would look like:

203948sdf 4 3 3 ysdifwier werioweir sdlfkwier jsdfj fjdj

 

[Tom Ellison]

Dear Julia:

Write a custom VBA function to do this one. In my estimate, there's going
to be a lot of extra effort in building all this functionality into a query.

Tom Ellison