Forum Discussion

Jaka75's avatar
Jaka75
Copper Contributor
Dec 07, 2023

excel

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?

 

Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Dec 07, 2023
    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.
    • Jaka75's avatar
      Jaka75
      Copper Contributor
      Dec 07, 2023
      Hi Harun
      thank you very much:-) it works!

Resources