Moving some contents of a field into another field
Have two fields; Address1 and Address2. I want to move some of the data from Address1 into Address2. Is there an easy way to do this.
For example: In Address1 we have 2055 Ocean Avenue, Apt 9. I want to move Apt. 9 to Address2 and delete the , Apt. 9 from Address1
Your help is greatly appreciated.