Mail merge
 

Our mailing contacts were saved in Cardbox (!!!!!!!!) and I have moved them
into an Excel spreadsheet. However, all the address components (street, city,
postcode) were in one field. Is there any easy way (I am an idiot) to
separate these companents into different Excel fields before I produce a mail
merge from the spreadsheet?

Mail merge
 

Hi,

You should be able to do it by selecting the column of addresses and then:

Data|text to columns

select delimited and click next
select the delimeter; presumably a space click next and finish

Mike

"Mozy" wrote:

Our mailing contacts were saved in Cardbox (!!!!!!!!) and I have moved them
into an Excel spreadsheet. However, all the address components (street, city,
postcode) were in one field. Is there any easy way (I am an idiot) to
separate these companents into different Excel fields before I produce a mail
merge from the spreadsheet?

Mail merge
 

I've already tried that but it doesn't work because some addresses may have 4
words, others many more which means that, for example, the city may appear in
column 4 or any column after that so not all corresponding elements of the
address are in the same column. But thanks.

"Mike H" wrote:

Hi,

You should be able to do it by selecting the column of addresses and then:

Data|text to columns

select delimited and click next
select the delimeter; presumably a space click next and finish

Mike

"Mozy" wrote:

Our mailing contacts were saved in Cardbox (!!!!!!!!) and I have moved them
into an Excel spreadsheet. However, all the address components (street, city,
postcode) were in one field. Is there any easy way (I am an idiot) to
separate these companents into different Excel fields before I produce a mail
merge from the spreadsheet?

Mail merge
 

Are the addresses separated by commas? For example 1236 3rd Street, Mytown,
mystate, zip? If so use text to columns, delmited, uncheck tab and check
comma.

"Mozy" wrote:

I've already tried that but it doesn't work because some addresses may have 4
words, others many more which means that, for example, the city may appear in
column 4 or any column after that so not all corresponding elements of the
address are in the same column. But thanks.

"Mike H" wrote:

Hi,

You should be able to do it by selecting the column of addresses and then:

Data|text to columns

select delimited and click next
select the delimeter; presumably a space click next and finish

Mike

"Mozy" wrote:

Our mailing contacts were saved in Cardbox (!!!!!!!!) and I have moved them
into an Excel spreadsheet. However, all the address components (street, city,
postcode) were in one field. Is there any easy way (I am an idiot) to
separate these companents into different Excel fields before I produce a mail
merge from the spreadsheet?