Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-21-2022, 12:42 AM
Muse1 Muse1 is offline How to delete everything outside angle brackets Windows 10 How to delete everything outside angle brackets Office 2021
Novice
How to delete everything outside angle brackets
 
Join Date: Sep 2022
Posts: 5
Muse1 is on a distinguished road
Default How to delete everything outside angle brackets

Hello
I have a long list of names, other info and email addresses. The email addresses are all within angle brackets. I need to remove everything outside the angle brackets, leaving me with a list of email addresses. Does anyone know how to do this using the find and replace function? I've tried this:


*\<\>*
But no luck.

Thanks
Reply With Quote
  #2  
Old 09-21-2022, 07:25 AM
macropod's Avatar
macropod macropod is offline How to delete everything outside angle brackets Windows 10 How to delete everything outside angle brackets Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You might try a wildcard Find/Replace with:
Find = \>*\<
Replace = ^p
At most, this should leave behind the content before the first < and after the last >.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-22-2022, 06:05 AM
Muse1 Muse1 is offline How to delete everything outside angle brackets Windows 10 How to delete everything outside angle brackets Office 2021
Novice
How to delete everything outside angle brackets
 
Join Date: Sep 2022
Posts: 5
Muse1 is on a distinguished road
Default

Thanks so much Paul! It worked perfectly.
Reply With Quote
Reply

Tags
find and replace

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and delet all text within brackets and the brackets themselves ranjan Word VBA 2 07-22-2021 01:06 AM
How to delete everything outside angle brackets find and delet all text within brackets and the brackets themselves wrdy Word 2 08-03-2017 06:55 PM
Microsoft Word macro to find text, select all text between brackets, and delete helal1990 Word VBA 4 02-05-2015 03:52 PM
How to delete everything outside angle brackets How to delete Grey Brackets in Word F10 Word 2 09-25-2013 12:07 PM
Macro help for right angle diagram. Jamtart PowerPoint 3 08-27-2012 06:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft