Escanaba
asked on
Excel 2007 Formula to Remove Null/#Value Results from Cell
Hello,
Using the following formula to split cells based on a certain character: =TRIM(LEFT(SUBSTITUTE(MID( A5,FIND("{ ",A5),LEN( A5))," ",REPT(" ",100)),100))
I am seeking assistance in tweaking this formula so if that character is not found in the cell it just returns a blank response instead of the #Value currently being shown.
Thanks
Using the following formula to split cells based on a certain character: =TRIM(LEFT(SUBSTITUTE(MID(
I am seeking assistance in tweaking this formula so if that character is not found in the cell it just returns a blank response instead of the #Value currently being shown.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.