I used the formula CONCAT(NUMBERVALUE(G2),"_",NUMBERVALUE(F2)) in Excel 365. But my colleagues are havindg the older version of Excel.But When they open the formula is showing as =xlfn.CONCAT(NUMBERVALUE(G2),"",NUMBERVALUE(F2)) and the result is not coming. Do you have any workaround like macro or something like that? When they open it should work.
Hi & welcome to the board.
How about
Formula:
Please Login or Register to view this content.
This means that you have used functions that are not compatible with the earlier versions.
You always need to test your formulae on the earliest version of Excel that they will need to work in.
I think CONCAT is available in 2016 and above, and NUMBERVALUE in 2013 and above.
Bad luck!
I suggest you start a new thread with a new title that explains what the formula is meant to do and how to adapt it for Excel 2010.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks