![reverse words in word reverse words in word](https://cdn.searchenginejournal.com/wp-content/uploads/2009/08/onelook-reverse-dictionary-531x400.jpg)
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) Click Insert > Module, and paste the following macro in the Module window. You can also use follow VBA to solve it.Ģ. If you have a list of cell words which are separated by commas as this “ teacher, doctor, student, worker, driver”, and you want to reverse the words order like this “ drive, worker, student, doctor, teacher”. Then drag the fill handle down to copy this formula, and the text in the cells is revered at once, see screenshot: And then save and close this code, go back to the worksheet, and enter this formula: =reversestr(A2) into a blank cell to put the result, see screenshot:Ĥ. Function Reversestr(str As String) As Stringģ. Click Insert > Module, and paste the following macro in the Modulewindow. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.Ģ. You can reverse the text with following steps:ġ. Supposing you have a range of text strings which you want to reverse, such as “ add leading zeros in Excel” to “ lec圎 ni sorez gnidael dda”. Reverse text string or words order with Kutools for Excel quickly and easily Reverse words order separated by specific separator with VBA code Reverse text string with User Defined Function
![reverse words in word reverse words in word](https://www.lifewire.com/thmb/_DREhHkWGMRNz5_mELOg3Otpu-o=/400x0/filters:no_upscale():max_bytes(150000):strip_icc()/how-to-rotate-text-in-word-1-5b843a7f46e0fb0050c1b365.jpg)
Normally this is somewhat difficult to solve this problem. Or sometimes you may reverse the words order such as “ Excel, Word, PowerPoint, OneNote” to “ OneNote, PowerPoint, Word, Excel”. When you use the Excel worksheet, how do you reverse the text string or words order in Excel? For example, you want to reverse “ Excel is a useful tool for us” to “ su rof loot lufesu a si lec圎”.
#REVERSE WORDS IN WORD HOW TO#
How to reverse text string or words order in Excel?