How to extract text between <>

LearnerExcel · #1 02-06-2018, 10:37 PM

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

macropod · #2 02-06-2018, 11:32 PM

=mid(a1,search("<",a1)+1,search(">",a1)-search("<",a1)-1)

LearnerExcel · #3 02-07-2018, 02:57 AM

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.

macropod · #4 02-07-2018, 04:27 AM

=trim(left(a1,search("<",a1)-1))

LearnerExcel · #5 02-07-2018, 06:11 AM

Thank you so much.

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
Extract text from a text string	Haha88	Excel	8	02-13-2017 05:06 PM
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