DashboardNovice
Member
In the attached file, I have a list of email addresses, in column D, then it is modified in column E to include a semi-colon.
In J9, I am concatenating all the email addresses, then pasting the values in J12. Then I can copy J12 and paste that into the 'To' field of Outlook.
This email list can be extensive. In J9, when I concatenate, I have to hold the 'Ctrl' key and select each cell in column E, which could mean many selections if the list is long.
In J9, is there anyway I can just select the entire range of modified email addresses in column E so I don't have to select each cell?
In J9, I am concatenating all the email addresses, then pasting the values in J12. Then I can copy J12 and paste that into the 'To' field of Outlook.
This email list can be extensive. In J9, when I concatenate, I have to hold the 'Ctrl' key and select each cell in column E, which could mean many selections if the list is long.
In J9, is there anyway I can just select the entire range of modified email addresses in column E so I don't have to select each cell?