This function returns the real coefficient of a complex number in the x+yi or x+yj text format.
IMREAL(complexnum)
The complexnum argument is a complex number for which to return the real coefficient.
An error is returned if the complexnum argument is not in the form "x+yi" or "x+yj". For more information, refer to Complex Numbers.
Accepts number and string data. Returns number data.
IMREAL("2-5j")