Excel 2003 Formula Equivalent

jpd101721

New Member
Joined
Jan 7, 2013
Messages
18
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
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
I dont have 2003 and would have thought that would work, but maybe try SUBSTITUTE insead of REPLACE

When you say it doesnt work - what doesnt work? is it giving an error message, the wrong answer, what?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,924
Messages
5,525,665
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top