Hi all,

I am trying to write a formula to remove the <!000> or similar from a column of entries. The problem is sometimes the <!000> is present and sometimes it isn't.


Here is an example of what is in column B:
<!080>example 1
<!090>example 11
<!100>example 111
<!110>example 2
example 22
example 211

I would like the end result in column A to be:
example 1
example 11
example 111
example 2
example 22
example 211

Is there an easy way to do this?

Thanks so much!