how do i create a formula in sheet2 with converted data from sheet1 in one
column.
i want formula in sheet2 to say.
if sheet1 column A is "issue" then put "i", if it's "days" put "d", if it's
"frank" put "f"

sheet1
A
1 issue
2 days
3 frank
4 apple

hope that make sense