Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge | Excel Discussion (Misc queries) | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
mail merge | New Users to Excel | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) |