Hello,
I am working on a project and i am extracting data the has numerical values through out one cell. Most of these contain a leading zero at the beginning. I am using the following formula below which works great, except it excludes the leading zero. I need the leading zero to be included. Any ideas?
=SUM(MID(0&A33,LARGE(ISNUMBER(--MID(A33,ROW(INDIRECT("1:"&LEN(A33))),1))*ROW(INDIRECT("1:"&LEN(A33))),ROW(INDIRECT("1:"&LEN(A33))))+1,1)*10^ROW(INDIRECT("1:"&LEN(A33)))/10)
as this is an Array formula you must use ctrl+shift+enter
I am working on a project and i am extracting data the has numerical values through out one cell. Most of these contain a leading zero at the beginning. I am using the following formula below which works great, except it excludes the leading zero. I need the leading zero to be included. Any ideas?
=SUM(MID(0&A33,LARGE(ISNUMBER(--MID(A33,ROW(INDIRECT("1:"&LEN(A33))),1))*ROW(INDIRECT("1:"&LEN(A33))),ROW(INDIRECT("1:"&LEN(A33))))+1,1)*10^ROW(INDIRECT("1:"&LEN(A33)))/10)
as this is an Array formula you must use ctrl+shift+enter