Getting rid of an imaginary component

[livvi_77]

Hello,

I've imported some data from matlab into excel and much of the data contains an imaginary component which I do not want can anyone help me think of a way to get rid of all of these? There are about 2000 data pieces so I don't want to do it manually. Thanks for your help in advance.

 

[SteveO59L]

What do you mean by "Imaginary Component" ?

Leading/Trailing spaces, non-printing characters ?

 

[Gerald Higgins]

I have no idea what matlab is, and I have no idea what an "imaginary component" is. Can you shed some light on this for the laypeople amongst us ?

 

[doublej_jj]

Are you getting data like:

45 + 5i
33 - 2i
etc?

If there is a space before the operation, you could do

=left(A1,find(" ",A1,1)-1)*1

This is my best guess what you are talking about.

Jeff

 

[Asala42]

If it's imaginary then you don't have to worry about it :D

Can you be more specific on what your seeing?

It may be a simple matter of using Edit/Replace, but we need to understand the logic behind what exactly you're trying to remove.

 

[Mr.Daines]

Hello,

I've imported some data from matlab into excel and much of the data contains an imaginary component which I do not want can anyone help me think of a way to get rid of all of these? There are about 2000 data pieces so I don't want to do it manually. Thanks for your help in advance.

try ctrl+F and select replace tab, in the find box put the character and in the replace box leave it blank or a space dependant on what you need.

HTH