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.