User Profile
Kay_Engineer
Copper Contributor
Joined Feb 10, 2023
User Widgets
Recent Discussions
Re: Identical Excel formula work on one sheet but no another
It is fixed now, it is a setting problem, please check the solution here in case anyone needs it. https://www.excelforum.com/excel-formulas-and-functions/1399559-identical-excel-formula-work-on-one-sheet-but-not-another.html#post57901079.6KViews0likes4CommentsIdentical Excel formula work on one sheet but no another
Hi I am working on a spreadsheet from my colleague and I would like to use the & function or the CONCAT() function however it is not working on the spreadsheet they left me, however, when I have created another spreadsheet myself, or another page, the formula works, may I ask if any one knows what makes the equation not working on one page but another. I have checking the cell format, the setting look the same to me. formula that works on both pages: =CONCAT("excel ",C9) formula that only works on the page I newly created: ="excel "&C9 =CONCAT("excel ", C9+1)Solved9.6KViews0likes8Comments
Recent Blog Articles
No content to show