Replace, delimit macro for x,y coorinates
Hi I am trying to create a macro that will allow me to replace ( , ) on several x,y coordinates and convert them into separate columns at once. For example
my villages opponents
as you can see I have a list of villages that i want to insert into the excel spreadsheet, which is an attack planner for a game that a lot of people play. Not only do I want the village coordinate but I also want the village name because once in the excel planner it will act as a link. Making it easier to set up a launch attack.
here is a copy of the attack planner that I created
what i need to do is take out the ( , and ) . The village points disappear when i replace and delimit one by one, which is ok by me. I just need coordinates. Now once the game grows we tend to attack from 100's of villages so if there is an easier way to do this, using a macro and created button I would be appreciative if you guys could help me with this.
Or if you have any suggestions that would also help me. Thank you so much.
Btw, I'm new to the forum.
Cheers!
Also, if there is a way to do this, will I still be able to sort the rows by launch time? Thanks again
Hi I am trying to create a macro that will allow me to replace ( , ) on several x,y coordinates and convert them into separate columns at once. For example
my villages opponents
as you can see I have a list of villages that i want to insert into the excel spreadsheet, which is an attack planner for a game that a lot of people play. Not only do I want the village coordinate but I also want the village name because once in the excel planner it will act as a link. Making it easier to set up a launch attack.
here is a copy of the attack planner that I created
what i need to do is take out the ( , and ) . The village points disappear when i replace and delimit one by one, which is ok by me. I just need coordinates. Now once the game grows we tend to attack from 100's of villages so if there is an easier way to do this, using a macro and created button I would be appreciative if you guys could help me with this.
Or if you have any suggestions that would also help me. Thank you so much.
Btw, I'm new to the forum.
Cheers!
Also, if there is a way to do this, will I still be able to sort the rows by launch time? Thanks again
