You've forgotten an INDIRECT.
Try
=IF(INDIRECT("Sheet1!E"&ROW())="","",(LEFT(INDIREC T("Sheet1!E"&ROW()),FIND("-",INDIRECT("Sheet1!E"&ROW()))-1)))
--
David Biddulph

"ah" wrote in message
...
Hi;

I've changed the formula to the following, but the wording of #VALUE!
still
appears to me:

=IF("Sheet1!E"&ROW()="
","",(LEFT(INDIRECT("Sheet1!E"&ROW()),FIND("-",INDIRECT("Sheet1!E"&ROW()))-1)))

Can you help me on this? Thanks a lot!


"Teethless mama" wrote:

=LEFT(A1,FIND("-",A1)-2)


"ah" wrote:

Hi;

Can anyone advice me on how to extract the text value only?
The formula that I'm using currently works well if the text value
appears
before the space only:

=(LEFT(INDIRECT("Sheet1!A"&ROW()),FIND("
",INDIRECT("Sheet1!A"&ROW()))-1))

My requirements are to appear all the text value, and skip the numeric
and
symbol.
For example:
a) For ABC - 123, it should appears as ABC to me
b) For ABC DEF -098, it should appears as ABC DEF to me.

Thanks for your help in advance.