Hello!
I work with Excel 2011 for MAC. At my office, my business manager works with Excel 2003. I created the following formula for extract General Ledger accounts, but it doesn't work with 2003. Does anyone know the equivalent formula for 2003?
=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A1,5,0,"-"),10,0,"-"),13,0,"-"),16,0,"-"),20,0,"-"),27,0,"-")
Thanks, Jack
I work with Excel 2011 for MAC. At my office, my business manager works with Excel 2003. I created the following formula for extract General Ledger accounts, but it doesn't work with 2003. Does anyone know the equivalent formula for 2003?
=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A1,5,0,"-"),10,0,"-"),13,0,"-"),16,0,"-"),20,0,"-"),27,0,"-")
Thanks, Jack