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

=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

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

There are worksheet functions for this -- IMAGINARY and
IMREAL. You may need to check the Analysis ToolPak add-in
to use them.

HTH,
Merjet

Try this

Call ExtractRI("string value in here")

Function ExtractRI(x As String)
r = Val(x)
i = Val(Right(x, Len(x) - Len(Str(Val(r)))))
End Function

Cheers
Nigel

"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

yeah, i should have thought of that

thanks
-----Original Message-----
Try this

Call ExtractRI("string value in here")

Function ExtractRI(x As String)
r = Val(x)
i = Val(Right(x, Len(x) - Len(Str(Val(r)))))
End Function

Cheers
Nigel

"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



.