Hey there,
I'm trying to add letters into blank cells - either "A" or "B", based on certain characters in other cells. The column has data in it with the format "STG.A39", where "STG." remains the same but the letters and numbers change in each row. I want to add an "A" in the empty column for any cells containing "STG.E" through "STG.K", and add a "B" for any cells containing "STG.A" through "STG.D". The numbers are irrelevant. I've attached a sample with Sheet 1 showing the original data and Sheet 2 showing the intended result. Thanks for the help!
Bookmarks