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.