Try this in A1 of Sheet2:

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

Copy down as required.

Hope this helps.

Pete

On Jun 18, 1:39*am, JaneSmith
wrote:
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