convert from rectangualr to polar

[Alfy]

I have a list of data in rectangular form (a+bi) and need to convert it
to polar form (a/_b) in order to find the magnitude. The phase angle
doesnt matter much just really need the magnitude. Any help on
achieving this would be of great help.
thanks;
Alfy

 

[Bill Martin]

I have a list of data in rectangular form (a+bi) and need to convert it
to polar form (a/_b) in order to find the magnitude. The phase angle
doesnt matter much just really need the magnitude. Any help on
achieving this would be of great help.
thanks;
Alfy

 

[Alfy]

in order to find the magnitude of the rect. form its just:
sqrt(a^2+b^2)
what i have is a form like a+bi so is there a way to apply formula t
the numbers? or possibly seperate a and b into seperate columns and g
from there

 

[Alfy]

is there a way to implement the formula to do the conversion in excel? I
have 2500 expressions( 5 sheets) = 12500 times i would i have to do it
manually. only need the magnitude from the rectangular form, so
r^2=a^2+b^2 where what i need is "r".

 

[Guest]

You can use data text to columns to extract the data (use + as the
delimiter). You can then use find and replace to delete the i in the second
column.

 

[Guest]

Hi,

If the data are in the format "a+bi" (e.g., 1.2+2.1i), try the following
formula (it is written for the contents of A1).

=SQRT(LEFT(A1,FIND("+",A1)-1)^2+RIGHT(LEFT(A1,LEN(A1)-1),LEN(A1)-FIND("+",A1)-1)^2)

Regards,
B. R. Ramachandran

 

[Alfy]

thanks! it seems to work, and i assume just change "+" to "-" when its
being subtracted...only what would you have to do if the first number
is negative?

 

[Guest]

Hi,

Try this much simpler formula.

=SQRT(IMREAL(A1)^2+IMAGINARY(A1)^2)

It should work for positive as well as negative real and imaginary components.

Regards,
B. R. Ramachandran

 

[Alfy]

thanks! :

 

[Dana DeLouis]

=SQRT(LEFT(A1,FIND("+",A1)-1)^2+RIGHT(LEFT(A1,LEN(A1)-1),LEN(A1)-FIND("+",A1)-1)^2)

Just to add...

=IMABS(A1)

will do the same thing.