AnsweredAssumed Answered

Excel macro question

Question asked by Chris Christy on Dec 9, 2019

I have XYZ point data from a txt file that I need to convert into a plain txt file, switching the Y and Z column. I need to make sure the data gets formatted into columns that are fixed width and separated by 1 space, similar to what I am attaching as the Output Data Format.

 

I have attached an example of the input data and output data. Is anyone good with Excel macros to make something that will convert it? I have attempted to bring into Excel and save out as both CSV and tab delimited but the columns seem to not line up properly on the rows that have data that takes up 8 spaces. You can see Output From Excel file to see what I mean. 10th row (Nr 73) shows the column offset I am talking about.

 

Thank you in advance.

 

Chris

Outcomes