What's the difference between UNICODE() and CODE()?

[Cubist]

I want to know the difference between the two functions UNICODE() and CODE(). Based on their Microsoft documentations,

UNICODE(): "This article describes the formula syntax and usage of the UNICODE function in Microsoft Excel."
CODE(): "Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer."

Similarly CHAR() vs. UNICHAR(). I'm trying to understand the use case preferences between the two. Thanks.

 

[Cubist]

I've always used UNICODE(). I just learned about the existence of CODE() today. They both date back to XL2013. It sparked my interest as to the reason why XL offers both. I don't think compatibility is an issue. As far as I can tell there are no cases where CODE() is preferred over UNICODE(). While UNICODE() is a superset of CODE().

 

[MARK858]

CODE() is older than EXCEL 2013, UNICODE() was brought into Excel 2013 to greatly extend the character set and so CODE() is backwards compatible for the older versions of Excel, whereas UNICODE is more flexible...
Horses for courses as the saying goes

 

[Cubist]

A little off topic now but how would one find documentation for functions pre-2013?
The best I can find is this page documenting Excel versions going back to Excel 1.0, which I'm tempted to download to see how people used to live, but not the functions.

 

[MARK858]

Techonthenet always seem accurate for a large range of functions (at least back to Excel 2000, not sure about before that), think they currently only go up to Functions that were there when 2019 was current (including the 365 functions at that time) but might be wrong on that

MS Excel: Formulas and Functions - Listed Alphabetically

Learn how to use all 300+ Excel formulas and functions including worksheet functions entered in the formula bar and VBA functions used in Macros. Here are the Excel formulas listed alphabetically. Choose one to get started:

www.techonthenet.com

Ellesa at StackExchange Superuser made a spreadsheet with a breakdown for what was available for 2003/2007 and 2010 versions based on MS listings for the individual versions (that I don't think you can into now)
Link to the spreadsheet below

Excel Functions: Compatibility Reference (2010, 2007 & 2003)

ALL FUNCTION,TYPE,XL 2010,XL 2007,XL 2003,DESCRIPTION <a href="http://office.microsoft.com/en-us/excel-help/HP010342136.aspx">ABS</a>,Math and trigonometry,yes,yes,yes,Returns the absolute value of a number <a href="http://office.microsoft.com/en-us/excel-help/HP010342133.aspx">ACCRINT</a>,Finan...

docs.google.com