View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default My formulas return the formula not a result in the cell

Try

="00-1-36000-21800 SPPNT HUGGIES GOODNITES"=LEFT(A2,16)


But that the text string is at least 40 characters so it can't be TRUE

--
Regards,

Peo Sjoblom

Portland, Oregon




"1stcoast" wrote in message
...
Cell A1
Formula in cell B1
00-1-36000-21800 SPPNT HUGGIES GOODNITES =LEFT(A2,16)

The calculation returns the formula not a result. What am I doing wrong?