Reversing?!?!

kpark91

Well-known Member
Joined
Jul 15, 2010
Messages
1,582
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
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

maninweb

New Member
Joined
May 25, 2010
Messages
21
Office Version
365, 2019, 2016, 2010
Platform
Windows, Web
Hi kpark91...

you can try the StrReverse function for reversing words; e.g. s = StrReverse("Hello")

Regards
 

kpark91

Well-known Member
Joined
Jul 15, 2010
Messages
1,582
Cool. I didn't know that kind of function existed.
Thanks.

But what's the code behind it? :P
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,971
Messages
5,508,473
Members
408,688
Latest member
Bhojraj

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top