Help Automating or trying to come up with a way to search and replace a text string.

I have a list of about 600 addresses that need to be reformatted with a space following X character and need to be in all caps. This would be the more tedious way because I would still need to search the other file to make sure the text itself is correct. I saw on a different forum that this line would work in adding a space (=REPLACE(A1,5,1,MID(A1,5,1)&" ")) but I need to add two spaces and adjust the location of the space so that it is following the first string of text.

The other approach could be to set up a formula or macro that searches the other file with a section of the original text and replaces that string.

If anyone could help with the basic formula (caps and adding two spaces following the first number string) or trying to macro a search and replace in the other file I would greatly appreciate it.