Just out of curiousity and since this seems to be the most active forum so..
What's the fastest way of reversing only words and sentences? :P
(without using excel's pre-established functions if any..)
Ex)
Hello my name is kpark91
Reversing words: olleH ym eman si 19krapk
Reversing sentences: 19krapk si eman ym olleH
For reversing sentences:
I was thinking along the lines of treating the string as an array of characters..
1) Find length of sentence
2) Loop for integer value of length of sentence divided by 2 (swapping first and last characters, 2nd and 2nd last characters, so on...)
For reversing words:
1) Use Split function to split the words
2) Use the same method as reversing sentences except it's for each word.
I was thinking of using these methods but then I found out excel didn't treat the string as an array of characters
Any ideas? :D
What's the fastest way of reversing only words and sentences? :P
(without using excel's pre-established functions if any..)
Ex)
Hello my name is kpark91
Reversing words: olleH ym eman si 19krapk
Reversing sentences: 19krapk si eman ym olleH
For reversing sentences:
I was thinking along the lines of treating the string as an array of characters..
1) Find length of sentence
2) Loop for integer value of length of sentence divided by 2 (swapping first and last characters, 2nd and 2nd last characters, so on...)
For reversing words:
1) Use Split function to split the words
2) Use the same method as reversing sentences except it's for each word.
I was thinking of using these methods but then I found out excel didn't treat the string as an array of characters
Any ideas? :D