how do you seperate multiple email address on excel ? I am trying to create a distribution list
Can separate the email by using the desired delimiter. using Split string
YourMail.Split(",")(0).tostring ----> email@example.com YourMail.Split(",")(1).tostring ----->firstname.lastname@example.org
If Need to seperate from the Text, use Regex
Hi @mma ,
Could you let us know more on how the data is arranged and how the emails are present ? If you could also provide the Expected Output for a Sample Input, we should be able to provide you with the proper suggestion.
Also, take a look at the email regex present in the Matches activity, which should be able to find the emails present in a text.
You can use the Split
- Read the cell that contains multiple email addresses.
- Use the Split function to split the email addresses into an array.
- Loop through the array and write each email address to a separate cell.
Here’s an example of how you can use the Split
emailAddresses = "email@example.com,firstname.lastname@example.org,email@example.com" emailArray = emailAddresses.Split(","c)
where will I put this on the excel sheet ?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.