Excel formula to extract Text or Number between Parentheses

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

КОМЕНТАРІ • 15

  • @m.averydortchjr1392
    @m.averydortchjr1392 3 роки тому +3

    You explained it clearly, so clearly in fact that even a guy like me could follow and make it work. Thank You.

  • @danbourek4615
    @danbourek4615 2 роки тому

    only watched the first minute- exactly what i needed. well done.

  • @TheRajasekar03
    @TheRajasekar03 3 місяці тому

    Very clear

  • @arjunridevlogs6763
    @arjunridevlogs6763 3 роки тому +7

    Kerala kaumudy news kandu vannavar evda like

  • @anoobantony6497
    @anoobantony6497 3 роки тому +3

    Very useful. Thank you ❤

  • @satyajay8276
    @satyajay8276 2 місяці тому

    Thank you..

  • @lorddragonmage4432
    @lorddragonmage4432 3 роки тому +1

    Great vid, thank you!
    Question: Can you take this one step further? I'm looking to be able to capture the data between the 2nd set of Parentheses. Some rows have a single set and some rows have two sets of parentheses. I only need the data from the right-hand set. So, the formula should take the data from the single set entries and only the right set of the double set entries. Is there a way to search from the right to the left?

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

    But I want just numbers not text. Suppose there are text and number in two different bracket sets how would I find just numbers between the brackets?

  • @RameshPatel-fg9qk
    @RameshPatel-fg9qk Рік тому

    Thanks, Today i used this Formula for % of total Marks In one cell..
    Like..348(4.9%)

  • @chowdharyinm3830
    @chowdharyinm3830 3 роки тому +2

    Can we make data entry form on excel in mobile?

    • @AjayAnandXLnCAD
      @AjayAnandXLnCAD  3 роки тому +2

      VBA interface which is essential for creating Data Form is absent in Excel for mobile.

  • @ranjithakalpathy4230
    @ranjithakalpathy4230 10 місяців тому

    👌👌👌👍🙏🙏🙏