Hello. I have an issue with open office, please see the attached spreadsheet. As you can see, the boxes that are highlighted I would like those 2 numbers separated and put into the next cell over. Example, Under the FG tab in K10 there are 2 numbers which appear as 29-70. I would like the 29 to stay in K10 and the 70 to move to L10. For all of the highlighted boxes to move over into the next cell as described. I copy and paste them into the cell in that format, so I would like to have those cells set up automatically to do so.
I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas, formatting, macro etc. thanks
Hello sir,
I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements.
So please contact me.
Tell me your quote what should you prefer.
First, allow me to introduce my self.
My Name is M Sutan Arif, my nickname is Sutan. I am from Bogor City, Indonesia. I am 18 years old
While I am in High School. I got 8 on Office exam
Thankyou Miss.
Respected Client,
Don't worry it just a easy task and I will do it for you.I will ensure as well that this type of errors of formulas not appear again.
Thanks..
Hello,
I could write you a macro which takes any cells that you highlight and splits any contents with a hyphen, with the left side remaining where it is and the right side moving to the adjacent column.
Regards,
Grainne