Your formula worked when Y=0 but not when X=0. I get the #VALUE error.
Did you get that kind of error? I am posting the data from the X
column

X Y
X3.8687 Y1.6025 3.8687 1.6025
X1.6025 Y3.8687 1.6025 3.8687
X0 Y4.1875 #VALUE! 4.1875
X-1.6025Y3.8687 -1.6025 3.8687
X-3.8687Y1.6025 -3.8687 1.6025
X-4.1875Y0 -4.1875 0
X-3.8687Y-1.6025 -3.8687 -1.6025
X-1.6025Y-3.8687 -1.6025 -3.8687
X0 Y-4.1875 #VALUE! -4.1875
X1.6025 Y-3.8687 1.6025 -3.8687
X3.8687 Y-1.6025 3.8687 -1.6025




On Apr 27, 2:54 am, Stefi wrote:
Your example contained both X=0 and Y=0 and I tested the formulae also for
these cases and they worked. Please post the exact data for which the
formulae don't work!

Stefi

" ezt írta:



Thanks for your help. Your formula doesnt work when X=0 or Y=0. Is
there a way to isolate that too? Thanks

Swamy

On Apr 26, 9:12 am, Stefi wrote:
For X value: =VALUE(MID(A1,2,FIND("Y",A1)-2))
For Y value: =VALUE(MID(A1,FIND("Y",A1)+1,256))

Regards,
Stefi

" ezt írta:

Hi,

I have a text file and in this text file, the data is like: -
X3.8687 Y1.6025
X1.6025 Y3.8687
X0 Y4.1875
X-1.6025Y3.8687
X-3.8687Y1.6025
X-4.1875Y0
X-3.8687Y-1.6025
X-1.6025Y-3.8687
X0 Y-4.1875
X1.6025 Y-3.8687
X3.8687 Y-1.6025

I have created two columns in the spreadsheet : X and Y. What I want
to do is to come up with a function that will read the X and Y values
from this input data. I will copy and paste this current data in one
column and in the other 2 columns, I must see X and Y values (in
numbers). I have tried using MID functions, but I am having problems
reading Y values. Any ideas?

Thanks- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -