Hi Ron,

That is a good idea. But I have to tell you that I'll be repeatedly
copying data from text files and pasting it on to A column. After I
get values for X and Y columns, I will copy that data and paste it
onto another workbook. I tried your method and it works for only the
data I posted. But if i copy and paste a fresh set of data onto column
A, the values dont change. I want to do this in a quick and efficient
manner as I have lots of text files.

Also I want X and Y columns to be together so I can easily copy that
off and paste it in another workbook.
Thanks for your help

Swamy

On Apr 26, 10:26 am, Ron Coderre
wrote:
With your posted data in Col_A beginning in A2

Since it appears that the data is effectively "fixed width", try this:

Select the Col_A data

From the Excel main menu:
<data<text to columns
Check: Fixed Width.............click [Next]
Insert break points: After the "x", Before the "y", After the "y"
Click [Next]
Set the 1st and 3rd columns to be SKIPPED
Set the destination cell to: B2
Click [Finish]

That should parse the x- values into Col_B and the y-values into Col_C.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP



" wrote:
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 -