如何在Excel中通過符號反轉域名？
如何在Excel中通過符號反轉域名？
有時，您可能會遇到通過符號反轉域名的工作，如下圖所示，您是否有任何技巧可以快速解決？ 在本文中，我介紹了兩種快速處理它的方法。
使用VBA通過符號反向域名
通過帶有反向文本順序的分隔符來反向字符串
使用VBA通過符號反向域名
驚人的！ 在 Excel 中使用高效的選項卡，如 Chrome、Firefox 和 Safari！
每天節(jié)省50％的時間，并減少數千次鼠標單擊！
這是可以幫助您的宏代碼，請在Excel中執(zhí)行以下操作：
1。 按 Alt + F11鍵 啟用 Microsoft Visual Basic應用程序 窗口。
2。 點擊 插頁 > 模塊，將代碼復制并粘貼到空白腳本中。
VBA：反向域名表示法
Sub Reverse()
UpdatebyExtendoffice2017115
Dim xArr() As String
Dim xSplitStr As String
Dim xVal As String
Dim xRg As Range
Dim xCell As Range
Dim xIndex As Long
On Error Resume Next
Set xRg = Application.InputBox("Select cells:", "KuTools For Excel", Selection.Address, , , , , 8)
If xRg Is Nothing Then Exit Sub
Application.ScreenUpdating = False
xSplitStr = "."
For Each xCell In xRg
If InStr(xCell.Value, xSplitStr) = 0 Then GoTo xBreak
xVal = ""
xArr = Split(xCell.Value, xSplitStr)
xIndex = UBound(xArr)
xVal = xArr(xIndex)
Do
xIndex = xIndex - 1
xVal = xVal & xSplitStr & xArr(xIndex)
Loop While xIndex > 0
xCell.Value = xVal
xBreak:
Next
Application.ScreenUpdating = True
End Sub
3. Press F5 key, a dialog pops out to remind you select a range to work.
4. Click OK.
Reverse string by a separator with Reverse Text Order
If you have Kutools for Excel, the Reverse Text Order feature can help you to reverse a string as you need.
Kutools for Excel, with more than 120 handy functions, makes your jobs easier.
Go to DownloadFree Trial 60 days
After installing Kutools for Excel, please do as below: （Free Download Kutools for Excel Now!)
1. Select the string you use, click Kutools > Text > Reverse Text Order.
2. In the Reverse Text dialog, select one option you need to reverse text based on.
3. Click Ok, and the text strings have been reversed.
Demo
Kutools for Excel: 300 + functions you must have in Excel, 60-day free trial from here
Best office Productivity Tools
Transform Hours into Minutes with Kutools for Excel!
Ready to supercharge your Excel tasks? Harness the power of Kutools for Excel - your ultimate time-saving tool. Streamline intricate tasks and glide through your data like a pro. Experience Excel at lightning speed!
Why You Need Kutools for Excel
??? Over 300 Powerful Features: Kutools is packed with more than 300 advanced features, simplifying your work in over 1500 scenarios.
?? Superior Data Processing: Merge cells, remove duplicates, and perform advanced data conversions – all without breaking a sweat!
?? Efficient Batch Operations: Why put in extra effort when you can work smart? Import, export, combine, and tweak data in bulk with ease.
?? Customizable Charts and Reports: Access a broad variety of additional charts and generate insightful reports that tell a story.
??? Powerful Navigation Pane: Gain an advantage with the robust Column Manager, Worksheet Manager, and Custom Favorites.
?? Seven Types of Drop-down Lists: Make data entry a breeze with drop-down lists of various features and types.
?? User-Friendly: A breeze for beginners and a powerful tool for experts.
Download Now and Soar Through Time with Excel!
Read More... Free Download... Purchase...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Read More... Free Download... Purchase...
Copy
版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發(fā)現本站中有涉嫌抄襲或描述失實的內容，請聯(lián)系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。
版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發(fā)現本站中有涉嫌抄襲或描述失實的內容，請聯(lián)系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。
相關文章
