mid

  1. R

    Using MID then IF to the result, is this possible?

    Hi! Not a seasoned user here so please be gentle :) How would I combine two formulas when one is dependent on the other? For example I am using the MID formula first to pull out letters I need. There are several answers that can be returned, but if the answer is BE, I would like it changed...
  2. bobgrand

    Move the character to the far right to another cell

    Hello all, I think I asked for help with this in the past but I can't seem to find anything in my history. I need to take the last character in A1 and put it in B1. Can't use the MID function because the number of characters can vary. <tbody> A B 1 20A08D D 2 PR115 5 </tbody>...
  3. S

    Using IF, MID and Vlookup

    I am using excel to help me track server information and I nee help with something. We are going to start using a new naming standard and I use the If and Mid and VLOOKUP statements not to look for a certain character in a cell to see if a system is production or non-production. The new naming...
  4. S

    Select only a part of the number in a field where thre digits are random

    Dear Forum, I have a problem with an Excel file where MID or LEFT don't work or maybe I am not using it right in D I have <tbody> A48662.401.01.65.112 445460.A48662.603.01.65.200 </tbody> etc now I need a column lets name it Z where it would show only the part "A48662.***" where the...
  5. P

    Compare 2 cells MID unknown location

    Hi, Can you please help me structure my Conditional Format? I have (with MREXCEL's help, Marcelo)-OR(MID(G2,5,3)=LEFT(H2,3),MID(G2,5,3)=LEFT(I2,3),MID(G2,5,3)=LEFT(J2,3),MID(G2,5,3)=LEFT(K2,3)). The problem is though that ColG source is from Manual entry where operators enter name, sometimes...
  6. Arie Bos

    Copy part of formula in other cell

    Formula in Y121: =((SUM(V116:W121)+SUM(S116:U121))/-SUM(S116:U121)) I want to copy the first part of the formula in the cell below, so "=((SUM(V116:W121)". When using the mid() function, it still returns the result value of Y121, but not the formula part. So, I thought the put the mid()...
  7. S

    Not sure if I need OR, AND or IF statement? Can you help?

    Hi, I'll try to explain the sheet setup ... Column F has one of two entries PROJECT SCHOOL Column AB can contain a department code or be blank MID CNC DEA EDU PGR CCT INT RIP (the list of codes goes on) In column AJ I want a formula that says if column F=school and column AB=INT or MID or EDU...
  8. J

    Sorting through Shelf Marks

    So I have an excel spreadsheet that I need to order in Shelf-Mark order. The Shelf-Mark is a thing with a mixture of numbers and letters, and completely variable lengths. For instance DVD WB365 MEB, QZ210 DIA, and OP121.96 and Excel doesn't like it very much. I've heard that the easiest way to...
  9. B

    What is the next number in the sequence?

    Can you please help me with figuring out the next number in the sequence? 601177520200013 601177520200021 601177520200039 601177520200047 601177520200054 601177520200062 601177520200070 601177520200088 601177520200096 601177520200104 I noticed that (Nth mid - (N-11)th mid) = 99 in...
  10. T

    How to extract "4/5.00" from cell with value "1.29(4/5.00 SAL)

    What formula can I use to get this? Also, can someone explain why it works? I tried using something like this, but no success: --MID(F2,FIND("(",F2)+1,10) Thank you!
  11. C

    Substitute and Trim Issue

    Hi, I am currently trying to pick out our order numbers beginning 'RVW0' from cells with long strings of text. I have succeeded so far... however! Some idiot has been using underscores and now they're messing up my sheets! I need my formula to ignore everything either side of the order number...
  12. M

    Extraction of a number of text from a middle of the cell

    Dear All, I need to extract a number from a cell containing : "Glass unit formula4-12-4-12-4И. R-value - 0,81 m² • С/W" or similar case. I have a problem with defining in a correct way the left, mid, find etc. Can you help?
  13. B

    Cell formula that returns the name of a table

    Couldn't find a built in formula to do this, and didn't want to write VBA. So found a way to get the name of a table in Excel. It's a little clunky and I'm hoping for a cleaner solution,but here it is. Used three functions: MID, FORMULATEXT, and INDEX. Have a table with name tblHarry 1...
  14. M

    MID / SEARCH error on the words "Spark" and "Park"

    Why does my formula in B5 and B6 break with the words "SPARK" and "PARK" (regardless of upper/lower case)? As you can see, replacing SPARK with SARK works fine. I think the issue lies in the MID part of the formula because it generated a result when I just used the SEARCH and LEN parts. Excel...
  15. J

    MID formula from VBA

    Hi there, I've pretty much usd all the words combination I could on Google and didn't find anything :'(... I'm trying to put excel formulas in dedicated cells, from my vba script. I've managed to do that using different ways, last one being : ThisWorkbook.Sheets(3).Activate...
  16. R

    Searching for a substring in a string after a specific number of specific characters

    I am trying to extract a substring from a string that contains a varying number of characters. Example: BLAH BLAH TRN#1#0000000000#9999999999 I would like to identify just the 0's in the example string. I have been using the MID function (below), but the issues is with the number of 0's. It can...
  17. M

    Extract Text From Variable Length String

    Hi! I'm trying to extract text from variable strings. Here is a string example: id="here_is_an_id" name="here_is_a_name" class="here_is_a_class" I want to extract the text inside name"". However that text length changes, and the fact that it's not the only item in quotes confuses me on...
  18. M

    Mid statement with different length of characters

    I will preface this with an apology, If i broke any rules with this post, I am sorry. My issue is as follows: I am looking to get a set of characters using a mid statement, but the amount of characters has grown. I need to be able to get 5 and 6 characters with the same function. My mid...
  19. E

    Extricate 1-3 Digit Numbers Before Certain Keywords

    I have an worksheet where I need to find all the weights (in kilograms and grams), but I only want to find the numbers (as I will easily be able to tell if they're KG or G just by the value it returns). If it's kilos, then the value I'm looking for could have 1 or 2 digits, and if it's in grams...
  20. E

    Countif Binary Strings w/ "1" in Position

    Hello, I am having a problem with counting specific binary strings (with the value of "1" in a specific position) and was hoping for some advice. I am importing data into Excel and converting each point to binary (I think this is the best way). An example: Event 1 has the value 001. Event 3...

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
Back
Top