I am using Excel to clean up a name and address list before
I export it to Access.

I now have parsed a field to yield the result 812 3340132
and for the final step I would like to remove the space between
812 and 3320132 and add a 1 to the front of the new number
which would then read 18123320132.

Can I do this as a Find and Replace action in the existing column
or do I need to create a new column with an entirely new formula?

Thanks in advance.