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.

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.
