Hi,
I’m getting a problem in Excel with some inbuilt function.
I’ve some data which is coming from SAP using BEx Analyzer and these data are using in some formula. But some times these data are coming either NULL or BLANK (I don’t know clearly about it). So when I’m trying to do some arithmetic operation then it getting error (#VALUE). To solve these I’ve used IF(LEN(TRIM(BEx(…))=0,0,BEx(…)). But I want to update these way and want to use just one function, i.e. trying to replace LEN(TRIM()) with a single function. So I’ve tried to use ISBLANK() function. But it’s now work as exact as LEN(TRIM()) function.
Please help me by providing only one function of MS Excel in spite of LEN(TRIM()).
Thanks in advance,
Suman
Bookmarks