4 Easy Ways to Remove Parentheses in Excel
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
In this video, I will show you four simple methods you can use to quickly remove parentheses in Excel.
The following methods are covered in this video:
Using Flash Fill
Using Find and Replace
Using the SUBSTITUTE Function
Using VBA Macro
You can download the example file from here - https://www.dropbox.com/s/4zjyqelp3th...
You can also read the tutorial here - https://trumpexcel.com/remove-parenth...
00:00 Intro
00:18 Remove Parentheses Using Flash Fill
02:12 Remove Parentheses Using Find and Replace
03:28 Remove Parentheses Using the SUBSTITUTE Function
05:34 Remove Parentheses Using VBA Macro
------------------------------------------------------------------------------------------------
'Code developed by Sumit Bansal from https://trumpexcel.com
Sub RemoveParentheses()
Dim rng As Range
Dim cell As Range
' Set the current selection as the range to be used
Set rng = Selection
' Loop through each cell in the selection
For Each cell In rng
' Remove parentheses
cell.Value = Replace(cell.Value, "(", "")
cell.Value = Replace(cell.Value, ")", "")
Next cell
End Sub
----------------------------------------------------------------------------------------------------------
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial
Watch video 4 Easy Ways to Remove Parentheses in Excel online without registration, duration hours minute second in high quality. This video was added by user TrumpExcel 22 June 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 18,937 once and liked it 503 people.