Inserting a value in a cell based off whether another cell has a letter in a string of numbers

[llglover]

I am building a spreadsheet that tracks military orders. Each order has a string of numbers that identify it and when that order is changed a letter is put into that string of numbers. Is there a way to insert a value in another cell if that letter exist in the sting of numbers? Example being below where I would like to have "Original", "Change" or "Delete" automatically populate based on whether no Letter, "G" or "R" exist in that cell. Thank you for your help in this!

55-1234-00595	Original
55-1234-00595G01	Change
55-1234-00595R00	Delete

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(ISNUMBER(SEARCH("R",A2)),"Delete",IF(ISNUMBER(SEARCH("G",A2)),"Change","Original"))

 

[llglover]

Thank you so much, that worked perfectly!!

 

[Fluff]

You're welcome & thanks for the feedback.