Get instant live expert help on I need help with excel substitute function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

want to understand difference between SUBSTITUTE and REPLACE function
Solved by G. Y. in 12 mins
Hey.. I need Substitute and Find function together
Solved by S. H. in 19 mins
my indirect function works but it returns a value error when I but the product function in front of it. (INDIRECT("'eVestment Data'!"&SUBSTITUTE(ADDRESS(1,((Y2-D3+1)*12+2),4),"1","")&ROW('eVestment Data'!A60)&":"&SUBSTITUTE(ADDRESS(1,MATCH($C3,'eVestment Data'!59:59,0),4),"1","")&60)) this formula works but as soon as i add product( 1+ Indirect...), it no longer works. Attached is the excel file
Solved by T. J. in 25 mins
i need a formula to substitute a word in excel
Solved by B. A. in 16 mins
Hello, I need help with IF and SUBSTITUTE formula in excel
Solved by A. A. in 19 mins