mutiple if formulas

  • Thread starter Thread starter JaneSmith
  • Start date Start date
J

JaneSmith

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
 
Try this in A1 of Sheet2:

=IF(Sheet1!A1="","",LEFT(Sheet1!A1,1))

Copy down as required.

Hope this helps.

Pete
 
Back
Top