Before posting this question, I searched extensively for an answered similar question but actually did not find any.
I'n in need to split ColA into 2 columns based on the number of words per each cell in the column.
If the cell number of words is odd, it should then be rounded off to the following even number before splitting.
Can I get some expert assistance with this issue please?
Many thanks in advance.
T.
Last edited by terryhenderson; 10-26-2018 at 12:38 AM.
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
More than stunning Karedog. Your genius code did it as exactly as it is needed smoothly and quickly. Please accept my cordial thanking.
I will mark this question as solved, meanwhile, is there any chance to modify the code to give me control over the number of words I want to split ColA by?
Once again, thank you very much indeed.
T.
Hi Terry, thanks for the compliment and rep.points.
As for your new question, just change the wordsToSplit value to a number as you wished.
Please Login or Register to view this content.
I'm more than grateful Karedog, you do have an invaluable addition to this world.
Thank you very much my dear.
T.
You are welcome Terry, glad to help.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks