Fourier Analysis in Excel
 

I am using the Fourier analysis in excel. The output of the analysis is a
column of real and imaginary numbers formatted in text. Is there any simple
way of separating the output to a column of real numbers and another column
of imaginary numbers? I need the magnitude of the output and cannot do
calculations on the text output.

Fourier Analysis in Excel
 

Hi Mitch,

I am using the Fourier analysis in excel. The output of the analysis is a
column of real and imaginary numbers formatted in text. Is there any
simple
way of separating the output to a column of real numbers and another
column
of imaginary numbers? I need the magnitude of the output and cannot do
calculations on the text output.

Use the IMABS, IMREAL and IMAGINARY engineering functions.

Ed Ferrero
www.edferrero.com

Fourier Analysis in Excel
 

Thanks Ed, that was helpful.

"Ed Ferrero" wrote:

Hi Mitch,

I am using the Fourier analysis in excel. The output of the analysis is a
column of real and imaginary numbers formatted in text. Is there any
simple
way of separating the output to a column of real numbers and another
column
of imaginary numbers? I need the magnitude of the output and cannot do
calculations on the text output.

Use the IMABS, IMREAL and IMAGINARY engineering functions.

Ed Ferrero
www.edferrero.com