How to extract substring within the characters < and >

manasaMS · 11/10/22

Eg: How to extract "chocolate@xyz.com" from "Choco Cookie <chocolate@xyz.com>".

Nick Korna · 11/10/22

This formula should do what you're after:

=MID(Value@row, (FIND("<", Value@row) + 1), (FIND(">", Value@row, 1) - (FIND("<", Value@row, 1)) - 1))

Hope this helps!

Nick Korna · 11/10/22

This formula should do what you're after:

=MID(Value@row, (FIND("<", Value@row) + 1), (FIND(">", Value@row, 1) - (FIND("<", Value@row, 1)) - 1))

Hope this helps!

Chizu Hieida · 04/11/23

@Nick Korna THANK YOU! This is exactly what I was looking for!!!!

Nick Korna · 04/12/23

@Chizu Hieida glad it helped! 😊

Best Answer