Thread
:
is Error help
View Single Post
#
1
Posted to microsoft.public.excel.misc
Jim
external usenet poster
Posts: 615
is Error help
Hello,
I'm currently using the following formula:
=TRIM(LEFT(A1,FIND("-",A1)-1))
How would I write this so that if the referred to cell is blank then the
cell I have the formula in shows blank instead of an error?
Thanks
Jim
Reply With Quote
Jim
View Public Profile
Find all posts by Jim