=IMREAL(A1)
&
=IMAGINARY(A1)

HTH
Dana DeLouis


"levent" wrote in message
...
can anyone think of an easy way to parse the real and
imaginary part of a complex number into two separate cells
in excel (using excel or VB)

2.111+0.34i = 2.111 0.34
-2.11-0.34i = -2.11 -0.34

i thought of cycling through the word using mid function
and checking for ascii values

thanks