Merging cells and keeping all the data/values
Hi, I have an exported data table that contains names and addresses. I need to have the address field "No, Street name, suburb, zip code, state" all in the one field. However this exported data table has these values in separate fields. How can I merge the fields and bring all the values into one single field.
thanks
Paul
|