separating combined numbers

Assume your number to be e.g., in E1.

In A1 enter: =LEFT(A3,SEARCH("+",E1)-1)
In B1 enter: =RIGHT(A3,SEARCH("+",E1))

or, if "i" is not wanted,

in B1 enter: =SUBSTITUTE(RIGHT(E1,SEARCH("+",E1)),"i","")

Aladin

Must be: A3 --> E1 (*NT*)

: This is an example of a number returned from fourier analysis. Is there some way to automate separating these numbers into their two data sets i.e. : col A 720.407 : col B 129.264 In B1 enter: =RIGHT(A3,SEARCH("+",E1))

You could use:

=left(the cell,7) in one cell for the first part

and

=MID(the cell,((FIND("+",the cell)+1)),7) to find the last half

Hope this helps.

Another way is to use Text to Columns, delimited, and select other as the delimiter, and then enter the plus sign (+) as the delimiter.

: This is an example of a number returned from fourier analysis. Is there some way to automate separating these numbers into their two data sets i.e. : col A 720.407 : col B 129.264 In B1 enter: =RIGHT(E1,SEARCH("+",E1))

you may want to change the formula to extract the right portion of the value to:

=RIGHT(E1,LEN(E1)-SEARCH("+",E1))

in case the "+" is not always in the middle of the string

Mark

Mark

You're right.

Aladin