I am importing the file from the some simulation software for fluid mechanics. The data I am getting is in this format a.jpg. I want to keep the data with x,y,z coordinates, while removing all other data.
Regards
I am importing the file from the some simulation software for fluid mechanics. The data I am getting is in this format a.jpg. I want to keep the data with x,y,z coordinates, while removing all other data.
Regards
attach a sample file (xls) for testing
If solved remember to mark Thread as solved
Dear Patel
Thanks for your time and prompt response.
Here is the sample file for your reference. Book1.xlsx
Thank again.
Kind Regards
Sijal
Last edited by Sijal; 10-06-2012 at 11:21 AM.
do you want coordinates in 3 separate cells , or as string as now ?
Last edited by patel45; 10-06-2012 at 11:49 AM.
Dear Patel
It would be even better to have coordinates in 3 separate cells, but even as string will do the job as I can convert them into column with command "text into column". I also need that the comma and other string should not be there with x,y,z coordinates.
Regards
Sijal
At the moment I just need the x,y,z coordinates whether separate or as string.
Give this a try
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Please Login or Register to view this content.
I missed that you wanted them put into separate columns try this
Please Login or Register to view this content.
Last edited by mike7952; 10-06-2012 at 12:12 PM.
Dear Mike and Patel
Thankyou for your help. I have tried the solution provided by Mike and it is awesome. But there is one problem in the last step. The x-coordinate which has two digits, the minus sign is missing. Any solution?
Best Regards
Sijal
Change this line. Make it +3 instead of +5
Please Login or Register to view this content.
Dear Mike
Thank-you very much. Problem is solved.
I also thank-you Patel and will give try to the VBA code you have just attached.
Best Regards
Sijal
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks