Find and Replace Function Syntax

[olga6542]

If I have a name that includes e-mail address Last Name, FirstName <...>; Last Name, First Name <..>; and so on.

If I only want to have the names listed on separate lines, which I can replace it with Paragraph Mark. What would be the syntax to remove <...;, that way I only have names?

[protonLeah]

You should post a better example. <..>; and so on isn't very helpful.

[olga6542]

<..>; means e-mail separated by ;

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!