Forum Discussion
complex numbers in format a+j*b, not in standard form a+b*j
Hi everyone! Long time, I would like to work with complex numbers in Microsoft Excel. I have a problem that I think here I can find one of the few people in the world capable of solving. If I...
if your imaginary number is in cell A2 this gets the real part:
=LEFT(A2,FIND("+",A2)-1)
and this gets the imaginary part:
=SUBSTITUTE(MID(A2,FIND("+",A2)+1,LEN(A2)),"j","")
=LEFT(A2,FIND("+",A2)-1)
and this gets the imaginary part:
=SUBSTITUTE(MID(A2,FIND("+",A2)+1,LEN(A2)),"j","")