Dear All, |
May I kindly request to help me with a formula to extract only? |
TO EXTRACT ONLY =0 BETWEEN BRACKETS IN EXCEL FORMULA 2016 |
[ 201=1 ][ 203=0 ][ 206=0 ][ 209=0 ][ 210=5 ][ 220=0 ][ 221=0 ][ 226=0 ][ 230=0 ][ 235=3 ][ 237=0 ][ 239=0 ][ 241=4 ] |
The expected answer should be like this |
[ 203=0 ][ 206=0 ][ 209=0 ][ 220=0 ][ 221=0 ][ 226=0 ][ 230=0 ][ 237=0 ][ 239=0 ] |
Or |
[ 203=0 ] |
[ 206=0 ] |
[ 209=0 ] |
[ 220=0 ] |
[ 221=0 ] |
[ 226=0 ] |
[ 230=0 ] |
[ 237=0 ] |
[ 239=0 ] |
Many thanks |