Using the Excel IMREAL Function

Summary
The Excel IMREAL function returns the real coefficient of a complex number in text format x + yi or x + yj.Use the COMPLEX function to convert real and imaginary coefficients into a complex number.
Syntax
=IMREAL (inumber)Syntax Breakdown
InumberRequired. Complex number for which you want to find the real coefficient.
Usage Notes
IMREAL returns the real coefficient of a complex number in text format x + yi or x + yj.Only use lowercase "j" and "i" in the IMREAL function. Other values result in the #NUM! error.