Excel INFO Function

While working on a spreadsheet, excel info function provides information regarding the existing environment. For example, spreadsheet number in workbooks, platforms, and much more. You need to provide the relevant information for using INFO function.

Syntax

The formula of excel info function is given below

=INFO (type_text)

Explanation

Excel info function easily recover 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

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar