parentheses

Hello, I am trying to learn what the text inside Parentheses () means. Because of not knowing what it means, I don't know what to properly call it. Just to clarify, I am not needing help with the VBA, I would like to know what the text within the parentheses is properly referred as. The only...

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!

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("...

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...

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...

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 =...

<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...

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...

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

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...

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...

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...

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...

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...

=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!!!!!!!!!!!!!!

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...

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...

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?

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...

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