How do I find more than 1 space between words in a text field, th.

S

sdhi

I have several text fields that contain 1 or more spaces between words. How
do I use Find and Replace to locate two or more spaces together and replace
two or more spaces with one space?
 
J

John Vinson

I have several text fields that contain 1 or more spaces between words. How
do I use Find and Replace to locate two or more spaces together and replace
two or more spaces with one space?
Click to expand...

I'm not sure you can with Find and Replace - have you tried just
typing two blanks in the Find line?

In an Update query you can update the field to

Replace([fieldname], " ", " ")

Keep running the query repeatedly until it has whittled down the
fields with " " to a single blank.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top