I changed my Excel files to .CVS and I need to import them into ACT!
The problem in the first names start in cell C2 and the last names start in D2. ACT! only has one place for names and will not import both cells to the same field. I have tried to to merge the cells, and even tried to combine the cells and enter the formula directly, nothing. I am using Excel on a Windows Vista machine. I need to get both first and last names in the C col. any advice or ideas are welcome.
Thanks in advance,