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

[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

 

[KARL DEWEY]

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

 

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

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

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

 

[KARL DEWEY]

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

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.

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

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