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?

Some videos you may like

This Week's Hot Topics