1. B

    Delete Entire column based on word search

    I'm not very good at VBA and am struggling to work out a way to search across the top row column headers and delete the entire column if the following words do not exist in the relevant text description of that column. The columns headers will have different text, but just in case it helps I...
  2. Nelson78

    VBA: loop in cells and delete bracket content

    Hello everybody. I'm looping in a range: For Each cell In Sheets(2).Range("F2:F" & lr3) '.... Next cell For each cell in this range, I need, if existent brackets with exactly 2 characters as a content, delete the brackets and its content. For example: LONDON (LD) has to be turned into...
  3. D

    Extracting data from within multiple square brackets

    Hi How would I extract the contents of the square brackets from the following? [A1] fjdlkfjsdlkjfalkdjfldksj [A5] ndjklafdkjda [A8] fjdlkfjsdlkjfalkdjfldksj [A2] ndjklafdkjda Ideally, I'd like the adjacent cell to contain, "A1, A5, A8, A2"
  4. J

    Removing everything outside brackets in a cell

    Hi!! I have a bunch of cells which contain data similar to "0.120 (3.048)". I want to delete everything out side the brackets. Is there an easy way to do this? Thanks in advance
  5. D

    Removing brackets

    Can someone help me with this function, I am trying to remove the RoundDown feature from the formula but it is not liking the brackets that I am removing. How should it look? The formula is...
  6. M

    Formula Not Returning Expected Value

    Can someone tell me why this formula is returning "FALSE" opposed to "YES" or "NO" ? I have a feeling the brackets are incorrect =IF(AND(($F$2>=A4),($C$2<=B4)),OR(IF(AND(($F$2>=A5),($C$2<=B5)),"YES","NO")))
  7. N

    VBA Extract and sum numeric values from bracket

    Hello, I had a code for this but I can find it anymore. Basically, I have a sheet with a column of alphanumeric values. At the end of each string I have a decimal value between brackets, but also some text. I would like to extract the numeric value only, sum all the extracted values with the...
  8. P

    MID Function to find a string within brackets

    Hello I am using the following: =MID(B5,SEARCH("[",B5)+1,SEARCH("]",B5)-SEARCH("[",B5)-1)+0 Where cell B5 has the following contents: =IF(B6="","rdhgxfjhsftjhjh(Text to extract)hujkfjkdjsdt","") and cell B6 is blank. I am receiving a #Value error, and am unsure why. My cells are formatted...
  9. C

    Macro that gets rid of brackets in formula as in the example.

    Hello, First time here, as I can't find the answer I'm looking for browsing the internet. Is there a way of writing a macro in excel that does this ? How do I get from this: (A/B/C)+(D/E) To this: A+D or A+E or B+D or B+E or C+D or C+E This is just an example, the macro I want to write is...
  10. D

    This formula to check if a text string contains a number in it - is it an 'array' formula?

    Found this post that has a formula that appears to do what I want > check to see if a text string has a number in it (any digit 0 thru 9): =COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A1))>0 But I see there's squiggly brackets, indicating an 'array', right? I've avoided array formulas in my file b/c I'm...
  11. A

    Curly Brackets but not an array?

    Hi I've been given a spreadsheet to work through and there's a formula that I've never seen before. It's =IF(SUM(COUNTIF(E3,{"*M*","*T*","*W*","*F*"})),"O","") The curly brackets are there whether Ctrl Shift and Enter is used or not. The only time I've seen curly brackets are for arrays...
  12. K

    need a macro to remove brackets and single quotes and sort

    I have words in a cell cell and would like to have the brackets and single quotes removed and put in alpha order. I have this in a single cell: ['red', 'blue', 'green', 'yellow']. I want this in a single cell: blue green red yellow
  13. D

    Split comma delimited data but ignoring commas between brackets

    Hi I have a set of data in the following format: <tbody> code other members modified ABC Babalwa Lobishe (Economic Development, Tourism and Agriculture), Fikile Desi (Constituency Coordinator), Thembinkosi Mafana (Safety and Security), Nomamerika Magopeni (Sport, Recreation, Arts and...
  14. R

    Caps in brackets

    Hi,, In column A I have very many phrases. Each phrase may or may not have one or more words in brackets. How can I make all the words in brackets written in capital letters? Thank you.
  15. L

    Is it possible to use variable in brackets when using .FormulaR1C1 ?

    Hello, I´m new to VBA and I wonder if you can put a variable inside the brackets when using .FormulaR1C1. Here is an example of what I´m trying to do: Sub b() Dim fl As Integer Dim fc As Integer Dim nb_parts As Integer Dim nb_measurments As Integer fl = 8 fc = 8...
  16. H

    Adding a sumif function into a formula

    Hi, I have written this formula, but it doesn't work! I am trying to add 1 to the result of the first formula (in brackets), if there is a '&' symbol in AZ10. I think what is confusing it is that I mean for it to look for a & within text, for example, 'Mr & Mrs Smith'. For this reason, I...
  17. bencar

    How Do I Know I Have an Array Formula?

    How do i know I have an array formula? For example, how do I know when to add brackets around this array formula? {B2:I2*B3:BI} And also with this? {=SUM((A1:A10="jim")*(B1:B10="ben")*(C1:C10="alice")*(D1:D10))}
  18. J

    VBA Remove anything in cell with brackets

    Hello, Is it possible to remove any text in a cell in brackets and the brackets please? Many thanks.
  19. L

    {=LINEST(E4:E43,F4:F43^{1,2,3},FALSE)} is strangely formatted

    I have not seen this format in a formula before. i understand the formula LINEST(), I've used it before what i dont understand are- -the curly brackets before and after the formula -the carrot with the numbers in curly brackets. can someone explain their purpose? Excel help is worthless for...
  20. K

    Conditional Format to Enter a Value in another Cell

    I want to conditionally format some values in a column based on the thresholds in the table below but I want the value in brackets to be entered in another cell. Threshold (1) Current (2) 0-30 (3) 31-60 (4) 61-90 (5) 91-120 (6) 121-150 (7) 151-180 (8) 180+ So if the value is between say 31 and...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...