Need to remove characters from a text string that appear after >

Emily McNeeley · 03/15/22

I have a column of data that some fields include extraneous data after the symbol ">" that I need to write a formula to remove. As an example, "ACCENTURE LLP>9I" should read as "ACCENTURE LLP" - what is the formula to remove the ">9I"?

Paul H · 03/15/22

=LEFT(Text@row, FIND(">", Text@row, 1) - 1)

Paul H · 03/15/22

=LEFT(Text@row, FIND(">", Text@row, 1) - 1)

Emily McNeeley · 03/15/22

Thank you!

Need to remove characters from a text string that appear after >

Best Answer

Answers

Help Article Resources

Categories