how to use replace formula

[lilyyangadsk]

Hello, can anyone teach me how to take away the mess words away which are both at beginning and end tail from the company name that I mark in Red color, what formula should I use to take them away?

<a href="/apex/salesaccountexplorer?id=0013000001FvC7Z" target="_blank">Taylor Fracasse Architecture Inc</a>

thank you

[danrh · Accepted solution]

Try this, should do the trick:

REGEX_Replace([Field1], '<.*?>', '')

 Hope it helps!

[lilyyangadsk · Accepted solution]

Thank you very much.