We can perform the same operation using COMPLEX to get the strings representing the complex numbers.
To read more about complex numbers in Excel, seethis article.
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary part of a complex number.
IMABS Function
The Excel IMABS function returns the absolute value of a complex number.
IMARGUMENT Function
The Excel IMARGUMENT function returns the angle of a complex number expressed in radians.
