parentheses

  1. B

    Formula? Extract text between 2 characters

    I need a formula to help the text below... Company Name (D-0003504825) to look like this 0003504825_Company Name On my excel worksheet, all text inside parentheses include "D" then "-" then 10 numbers. Thanks!
  2. P

    Extract value between parentheses

    Hi, I have the following string in Cell A1: 1. First Name (5). I figured out how to extract the first and last name. I am struggling on how to get the value between the parentheses. The values will range from single-digit to triple-digit. Forluma to get the name value: =MID(A2,FIND("...
  3. R

    replace parentheses and dashes from list of #s

    I have a list of numbers in static columns (let's stay columns D and E have the home and business phone numbers) that need to have all dashes, spaces and parentheses removed. Raw: (213) 345-4567 Desired: 2133454567 I know I can do this via formulas and such but I would prefer to do this via...
  4. R

    Re: How to find the most SEQUENTIAL occurring numbers in 1 column

    Re: How to find the most SEQUENTIAL occurring numbers in 1 column how do i sort the numbers in a row in numerical order?For example the data looks like this and starts at C2 (I re-sorted it), so how do I get the data to read "1" on L2, "4" on M2, "10" on N2, "18" on N2, and "26" on O2. All of...
  5. M

    split string at every nth Word but ignoring counting those in parentheses

    I am using the following UDF to split a long string into rows of predefined number of words in based on input incell "D3". Public Function SplitOnNth(ByVal inputStr$, ByVal StartPos&, ByVal NumWords&) As String Dim arr() As String, i As Long, newArr() As String arr =...
  6. J

    Extract 1st, 2nd, and 3rd instances of text between Parentheses

    <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br...
  7. M

    Highlight certain text in a cell - with varibles

    I have a large excel spread sheet with the following characters repeated: (CD #####). The #### are replaced for different situations. For example one instance might be CD 1-1 or CD 13-5, etc. I have seen that there are VBAs that can be used to color texts but I am looking to HIGHLIGHT the...
  8. D

    extract number in string between parentheses

    In access office 365 In a query... I have a field with a string that varies in length, where the end is always a number between parentheses. example walk to work (4) eat a salad with water (7) How can I extract the number between the parentheses using a query. 4 7 Thank in advance
  9. N

    Parentheses Problems

    Hello...My name is Devin, and I am planning to host a dinner among friends and acquaintances at a large dining hall within the next two weeks. I am playing around with a formula that will allow me to seat people who I think MIGHT be a good match for conversations(maybe); people who I think WILL...
  10. M

    USERNAME weirdness

    I have a simple DAX measure in my Excel 2016 data model: [Who Am I Domain]:=USERNAME() When I enter this as a measure in the data model window and use autofill the end parentheses appear. However, after the measure calculates the parentheses disappear (which they don't do for...
  11. D

    Extracting content from cell with multiple parentheses

    I am looking for a formula expression that will let me extract from a cell that contains multiple parentheses to another cell ,specifically in the 2nd instance of parentheses. The cell content looks like this; OC (77G201)(A4T201) OC (ITPN)(GTHS) As you can see the cell content length can vary...
  12. L

    currency vs accounting

    Hi I wanted to know the difference between currency and accounting number formatting. Excel easy website is saying this: "Note: the Currency format can display negative numbers with a minus sign, in red, with parentheses, or in red with parentheses. The Accounting format displays negative...
  13. J

    Varying LEFT Function

    In column A I have varying input data that I need to adjust. I'm trying to eliminate the parentheses and the 1 or 2 digit numbers within. Column A I've got data like 15 C.Smith(5) 9 F.Forsberg(12) etc. the number in the parentheses increases as the season progresses. In column B I'm...
  14. R

    Help make my formula work (please)

    =IF(I8="No"),((SUM('All Distrib'!J3:J810),If(I8="Yes"),(SUM('All Distrib'!J3:J810)*I$9)) I need this information but parentheses are wrong (sigh). Very bad at nesting. Help would be so lovely. Thank you!!!!!!!!!!!!!!
  15. I

    Pulling specific text from between Parentheses ()

    So here is my dilemma. I have a worksheet I export daily and it contains the name of the individual who opened the account but is have the name inside parentheses. I have another worksheet that has just the account number and I need just the individual name from the other worksheet. I have...
  16. A

    Nested IF, parenthesis

    Hello - Excel is telling me that I have an error with this formula. Does anyone have an idea of what it might be, and why? Thank you very much...
  17. R

    Make parentheses more visible in a long Excel fomula

    Is there any way to make parentheses more visible in a long Excel formula? I am trying to analyse it and although parentheses are in different colours it is still difficult to match teh opening one with the closing one. I just wonder if there is some trick to make it easier?
  18. A

    Multiple IF AND OR

    Hello - Thanks for taking a look at this - I have been trying to get this right, and I keep on getting an error. I know it must be in the parenthesis syntax (at a minimum), but I am missing something...any help will be very much appreciated! This formula works fine...
  19. T

    VBA to read values in parentheses as positve

    I need vba code to read values in parentheses as positive An if statement would be perfect. Sort of If (3) Then 3. Thanks Tom
  20. P

    Find all instances of parentheses in a call and replace with an S

    Hello - Looking for a FORMULA that can find all instances of parentheses and replace with an S. There can be up to 50 parentheses in a cell if that matter. A1 = H2N-(dA)(dVaaaa)(Dava)(dC/CyMal)-OH A2 - H2N-SSSS-OH Possible?

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top