Extracting the rest of a cell if the first character matches a value

[laundon]

Hello,

I have a spreadsheet, and a cell starts with either ">"or "<" and then followed by a string, for example ">ABC123" or "<XYZ123". I need to analyse the first character, and depending on whether it's true or not, extract the remaining cell information.

In English, the command would be, If cell A1 starts with a ">" then extract the remaining characters after the ">" or else return blank.

Any ideas you lovely people!

Many Thanks,
Tim.

 

[Rick Rothstein]

Does this formula do what you want...

=IF(LEFT(A1)=">",MID(A1,2,LEN(A1)),"")

 

[laundon]

Superb! Thank you so much!
It actually looks straight forward now you've shown me, but I just couldn't get my head around it!

Thanks once again