I want to update "P O BOX" to "P.O. BOX"

K

Kelvin

I have address data that looks like this
"P O BOX 123"
I want to replace "P O BOX" with "P.O. BOX"
To end up with "P.O. BOX 123"

All the options I've tried drop the numbers...

Any help would be appreciated!

Kelvin
 
K

KARL DEWEY

Use an update query with this ---
Replace([YourField],"P O BOX", "P. O. BOX")
 
K

Kelvin

I should have used a different example.

I want P O BOX 123
to be P.O. BOX 123

I want the PO BOX part to change but leave the rest the same.



KARL DEWEY said:
Use an update query with this ---
Replace([YourField],"P O BOX", "P. O. BOX")
--
KARL DEWEY
Build a little - Test a little


Kelvin said:
I have address data that looks like this
"P O BOX 123"
I want to replace "P O BOX" with "P.O. BOX"
To end up with "P.O. BOX 123"

All the options I've tried drop the numbers...

Any help would be appreciated!

Kelvin
Click to expand...
Click to expand...
 
K

KARL DEWEY

What did not work when you used what I posted?
--
KARL DEWEY
Build a little - Test a little


Kelvin said:
I should have used a different example.

I want P O BOX 123
to be P.O. BOX 123

I want the PO BOX part to change but leave the rest the same.



KARL DEWEY said:
Use an update query with this ---
Replace([YourField],"P O BOX", "P. O. BOX")
--
KARL DEWEY
Build a little - Test a little


Kelvin said:
I have address data that looks like this
"P O BOX 123"
I want to replace "P O BOX" with "P.O. BOX"
To end up with "P.O. BOX 123"

All the options I've tried drop the numbers...

Any help would be appreciated!

Kelvin
Click to expand...
Click to expand...
Click to expand...
 
Top