Excel INFO function returns information regarding the existing environment: spreadsheet number, workbook number, and platform. However, there are several requirements that need to be provided as below:
Syntax
=INFO(type_text)
Explanation
The INFO function easily recovers data of the existing environment such as OS version, OS, and Excel versions. You need to provide the kind of information that you wish to be recovering as text. You can request your desired information from the following categories:
Example
In this example, we have provided the desired information to recover data as text form as shown in the figure. The INFO formula for the B5 is
=INFO(B5)
Figure 1. Example of Excel INFO function
Leave a Comment