excel

Copper Contributor

Hello

We have exported an excelfile from our Visma administration program in order to use the emails for newsletters. However, there is an "equal to" sign and hyphens around the names and the e-mail adresses (see attached screenshot) which prevents us from searcing in the file and from importing the e-mail adresses into mailchimp. How do we remove the signs?

 

excel exempel.JPG

2 Replies
You do not have any email address in screenshot. You have only text. I would suggest to use TEXTSPLIT() function to split emails in a new column then delete old column.
Hi Harun
thank you very much:-) it works!