Chat GPT and Excel mailing list

 I have some mailing lists I maintain by pulling up the old email of 30 names and "REPLY TO ALL" with a new monthly email mailing.

I want to convert to a system in Excel.   The excel will have names and emails down Column A and B.

A                    B

Joe Man        joe@man.com

If I can get in this format, I can use an Excel command to generate concatenated emails that my email will easily recognize.

Joe@man.com; Tom@man.com; Mary@man.com 

####

Myt problem: How do I get from a big block of names and brackets and emails, which I've cut and pasted from my email outbox, to the A, B format I want in Excel.   (I will maintain, add, delete, from the Column A and B system).

####

My problem framed for CHAT:

I have a set of names and <emails> in the following semicolon delimited format.  It is currently in WORD.  I would like to create an excel spreadsheet that show the name in column A and the email - without brackets - in Column B.   Can  you helpe me produce that?  Of course, I could do it very very slowly and manually, but I prefer not to.   ##### Joe Smith <joe@smith.com>; Mary Jones <mary@jones.com>; Bob Ryan <bob@ryan.com>; etc.

###

Adjusted Method

Step 1: Prepare the Data in Word

Replace the Opening < with a Tab Character:

Use Find and Replace (Ctrl + H) in Word.

In the Find box, enter <.

In the Replace box, enter a tab character ^t. This will replace the opening angle bracket with a tab, effectively separating the name from the email address.

Replace the Closing > and Semicolon ; with a Newline Character:

Again, use Find and Replace.

Find >; and replace it with a newline character ^p. This will place each name-email pair on a new line.

After these replacements, each line in your Word document should consist of a name, a tab, and then the email address, without any angle brackets.

John Smith  [tab]  john@smith.com

Step 2: Copy Data to Excel

Select and copy the modified data in Word (Ctrl + C).

Open Excel.

Paste the data into Excel (Ctrl + V).

The names should now be in column A, and the email addresses, without angle brackets, should be in column B.

This method ensures that both opening and closing angle brackets are removed before the data is copied to Excel, simplifying the process and eliminating the need for further manipulation in Excel.

####

I know from another Chat exchange, that if I can get the emails into columns in Excel, I can "concatenate" them into a long list of emails separated by semicolons that I can paste into a COPY: box in my email.

TEXTJOIN("; ", TRUE, A1:A3) 

Note that in our example above, I would use array B1:Bn since the emails are sitting in column B.