Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2018, 10:37 PM
LearnerExcel LearnerExcel is offline How to extract text between <> Windows 7 32bit How to extract text between <> Office 2003
Advanced Beginner
How to extract text between <>
 
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default How to extract text between <>

How to extract the text between <> as shown in the below example:



Cell A1 Contains : Company Coordinator <coordinator@abc.com>
And the result shall be in Cell A2 : coordinator@abc.com
Reply With Quote
  #2  
Old 02-06-2018, 11:32 PM
macropod's Avatar
macropod macropod is offline How to extract text between &lt;&gt; Windows 7 64bit How to extract text between &lt;&gt; Office 2010 32bit
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

=mid(a1,search("<",a1)+1,search(">",a1)-search("<",a1)-1)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-07-2018, 02:57 AM
LearnerExcel LearnerExcel is offline How to extract text between &lt;&gt; Windows 7 32bit How to extract text between &lt;&gt; Office 2003
Advanced Beginner
How to extract text between &lt;&gt;
 
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default

Thanks for the spport. It's working fine.
Can I get the remaining text before < (Ex. Company Coordinator) in Cell A3 as well? It will save my time when there are lot of contacts wich required to be seperated by name as well as email address.
Reply With Quote
  #4  
Old 02-07-2018, 04:27 AM
macropod's Avatar
macropod macropod is offline How to extract text between &lt;&gt; Windows 7 64bit How to extract text between &lt;&gt; Office 2010 32bit
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

=trim(left(a1,search("<",a1)-1))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 02-07-2018, 06:11 AM
LearnerExcel LearnerExcel is offline How to extract text between &lt;&gt; Windows 7 32bit How to extract text between &lt;&gt; Office 2003
Advanced Beginner
How to extract text between &lt;&gt;
 
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default

Thank you so much.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to Extract text from a text string Haha88 Excel 2 11-14-2017 01:32 AM
How to extract text between &lt;&gt; Extract text from a text string Haha88 Excel 8 02-13-2017 05:06 PM
How to extract text between &lt;&gt; I'm looking for a formula to extract all the text before the last name in a cell Gef Excel 4 02-01-2015 07:14 PM
Is there a way to extract various text in Word? barnkeeper410 Word 4 07-08-2013 10:58 PM
extract text with formula s7y Excel 7 06-05-2013 06:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:39 PM.


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