Remove spaces text field

  • Thread starter paulmitchell507
  • Start date
G

glenda beckstead

÷Ðñ said:
÷Ðñ·¢²¼ÐÂÎÅ×éÐÅÏ¢
lizhenglang said:
Steve Schapel said:
Paul,

If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")

--
Steve Schapel, Microsoft Access MVP


My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]

I have already received advice removing alpha, or nonnumeric,
characters.

Paul
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove non numeric characters from field 4
parse some text from an inconsistent text field 6
isolate a number in cell with text and numbers 24
Remove spaces from text field telephone numbers 1
how do I remove a space in a text value? 2
Removing specific characters from a text field 1
Excel truncates text strings of spaces? 3
Zip Code Macro 1

Top