4 Easy Ways to Remove Parentheses in Excel

Поділитися
Вставка
  • Опубліковано 29 жов 2024

КОМЕНТАРІ • 28

  • @trumpexcel
    @trumpexcel  Рік тому +4

    If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
    Also, I have made all of my Excel courses available for free. You can check these out using the below links:
    ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
    ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
    ✅ Free VBA course - bit.ly/excel-vba-course
    ✅ Free Power Query Course - bit.ly/power-query-course

  • @Satwant2463
    @Satwant2463 Рік тому +2

    Unique feature and very useful. Thank you.

    • @trumpexcel
      @trumpexcel  Рік тому

      Glad you found the video useful 🙂

  • @chuo777
    @chuo777 Рік тому +1

    Macro works like a charm

  • @nadermounir8228
    @nadermounir8228 Рік тому +1

    Thank u Sumit for this great video 📹 😊

  • @arindambhattacharya7318
    @arindambhattacharya7318 Рік тому

    Share more excel tips and tricks which is usually used in bpo.

  • @kalalramulugoud7494
    @kalalramulugoud7494 Рік тому +1

    Thank Sir ❤

  • @payaljain5497
    @payaljain5497 Рік тому

    Hi Sumit...if you could please make few videos on Excel 365 popular formulas with examples please ...

  • @lazyreviewssupport9811
    @lazyreviewssupport9811 Рік тому +2

    Good one... 👏...
    1:53 Seems data in A7 do not match with data in B7

    • @trumpexcel
      @trumpexcel  Рік тому +1

      Yeah, I didn't notice it. One of the cases where Flash fill wasn't able to identify the pattern right, so maybe give more entries manually and then use Flash Fill

    • @lazyreviewssupport9811
      @lazyreviewssupport9811 Рік тому +1

      @@trumpexcel what 😲 could be causing the problem 🤷‍♀️... It's not that parenthesis are not being removed... 😵 But new data is being added 😨

    • @sumit.bansal
      @sumit.bansal Рік тому +1

      @@lazyreviewssupport9811 yeah, this is weird. I have seen it give wrong results, but adding stuff on its own is new. I am sure it has to do with how it identifies the pattern and decides what to remove and what to keep. I am away from my system, but will come back and try to decode why this is happening

  • @AhmadSaleemButt
    @AhmadSaleemButt Рік тому +2

    Useful feature but please be noted while applying flash fill method, what happens in 7th row is that "New" appears twice. Could you please give the reason for that?

    • @trumpexcel
      @trumpexcel  Рік тому

      I believe this is happening because in all the other cases there is only one word within parentheses, but in A7 there are two words within parentheses so Flash fill gets confused with the pattern. A good example of why flash fill could sometimes giving incorrect results

    • @vivekjoshi3769
      @vivekjoshi3769 Рік тому

      @@trumpexcel Would it happen if it was written as New-York instead of New York?

  • @ramashanker
    @ramashanker 11 місяців тому

    How can I send an excel file to you or attach an excel file for you to see?

  • @souvikdas9110
    @souvikdas9110 9 місяців тому

    I will definitely choose substitute function 😅

  • @xeeshanahmad8757
    @xeeshanahmad8757 Рік тому

    👍

  • @sarfarajakhtar493
    @sarfarajakhtar493 11 місяців тому

    I have a table with customer name, sales stage, amount, Year and Month of each sales stages. There are 4 types of sales stages like lead, opportunity, demo and proposal. I keep on changing the sales stages based on the latest sales update from customer. I want to create a sales pipeline dashboard in excel sheet. I want t dashboard with chart of sales stages and slicer of month and year. I want the chart of sales stage should be changed based on selection of month and year.
    For an example- I have created a lead in August 2023 then change the stage to demo in September 2023 and then again change the stage to proposal in October 2023. Now if Select September in dashboard slicer the chart should show Lead-0, demo-1 and proposal- 0. Similarly when I select October then chart should show Lead-0, demo-0 and proposal- 1.
    Please help to create similar dashboard in excel sheet.

  • @hari-analyst7915
    @hari-analyst7915 Рік тому

    I'm unable to download material in your website bro, please let me know, how to get material

    • @trumpexcel
      @trumpexcel  Рік тому

      Can you please let me know what are you not able to download? Will fix it.

  • @StarLight-xu5lk
    @StarLight-xu5lk Рік тому

    Hi, i am trying to create time in lieu spreadshit to capture time work, time accrued and time taken, just like with leave tracker you created. If you could guide me on this it would be greatly appreciated.

  • @abhinavgaddam2950
    @abhinavgaddam2950 Рік тому

    In VBA what if i need to remove even text in parentheses?

    • @trumpexcel
      @trumpexcel  Рік тому

      Try this:
      Sub RemoveParentheses()
      Dim rng As Range
      Dim cell As Range
      Set rng = Selection 'change this to your range
      For Each cell In rng
      cell.Value = RemoveParenthesesInString(cell.Value)
      Next cell
      End Sub
      Function RemoveParenthesesInString(s As String) As String
      Dim openParen As Integer
      Dim closeParen As Integer
      openParen = InStr(s, "(")
      closeParen = InStr(s, ")")
      While openParen > 0 And closeParen > 0
      s = Left(s, openParen - 1) & Mid(s, closeParen + 1, Len(s))
      openParen = InStr(s, "(")
      closeParen = InStr(s, ")")
      Wend
      RemoveParenthesesInString = s
      End Function

  • @meetkcs
    @meetkcs Рік тому

    The Easiest way : Flash Fill.
    But, in the 7th Row: NEW is repeated TWO TIMES !! What could be the reason for that ?

  • @donnaallison5497
    @donnaallison5497 Рік тому

    "Promosm" 🤦

  • @serdip
    @serdip Рік тому

    Another great video that provides very useful and practical tips for cleaning data in Excel! Thanks very much for posting.
    Another option would be to use Power Query to easily remove the unwanted characters. As far as I can tell, however, the Replace Values feature works with one character at a time, similar to VBA's Replace() function. I was wondering if it were possible to use a custom M language function that accepts one or more characters to remove from a given string. Below is my attempt at addressing this issue. Since I have only been studying Power Query for three weeks, I assume that what I wrote is pretty awful and inefficient. But it does seem to work, based on my very limited testing. Thank you kindly.
    ===============================================
    // fxRemoveChars()
    // Remove one or more characters from the input string and
    // return the modified string.
    // Text.SplitAny() will break up the input string on all of
    // the specified delimiters, which are the characters we want to remove.
    // Then reassemble the list object returned by Text.SplitAny()
    // into a text string and return its value.
    (input as text, remove_chars as text) =>
    let
    split_input = if input null
    then Text.SplitAny(input, remove_chars)
    else null,
    output = if split_input null
    then Text.Combine(split_input, null)
    else null
    in
    output