Hi,
I work in a group of 8 people. We are moving from Outlook to Goldmine. I exported the 8 contact databases from Outlook to Excel and have been cleaning and enhancing the data in excel, eliminating duplicates, using consistent company names and so on. When fully cleaned I will import into Goldmine as a starting common database for all 8.
I have hit a problem trying to use Excel's Text to Columns feature. Many of the address records have imported into excel in one column, with as a delimiter between address line 1 address line 2 etc. When I try to get Excel's Text to Columns to recognise this , I cannot. I can use Character MAp to get a in the dialog box but Excel ignores it and I'm left with just the first line after the process runs with subsequent address lines being lost.
How can I proceed to split up my address lines into separate fields
Thanks.....John (Dublin, Ireland)
I work in a group of 8 people. We are moving from Outlook to Goldmine. I exported the 8 contact databases from Outlook to Excel and have been cleaning and enhancing the data in excel, eliminating duplicates, using consistent company names and so on. When fully cleaned I will import into Goldmine as a starting common database for all 8.
I have hit a problem trying to use Excel's Text to Columns feature. Many of the address records have imported into excel in one column, with as a delimiter between address line 1 address line 2 etc. When I try to get Excel's Text to Columns to recognise this , I cannot. I can use Character MAp to get a in the dialog box but Excel ignores it and I'm left with just the first line after the process runs with subsequent address lines being lost.
How can I proceed to split up my address lines into separate fields
Thanks.....John (Dublin, Ireland)
