mid

Hello, I need to highlight cell depending on min, mid and max value in 3 different colours. Is it possible to with conditional formatting? Like this... Book1DEF415524556124407805109101029Sheet1 Thank you all Excel 2000 Regards, Moti

Hi everyone, I'm re posting this as my previous thread was a bit confusing and didn't get any replies. I would like column D:D to be populated with a function rather than manually. This column contains H codes taken from E:E. The codes are in this format: H0xx-H9xx (4 characters, first...

Hi, Is there a way to select cells mid macro with the mouse that doesn't use the input box to show what is being selected? but also wait to resume code until cell is clicked?

I'm sorry that I'm posting this in a rush so this may not be the best way to illustrate my problem - but here's an idea of what I want and how I'm getting it now: <tbody> A B C D E F G H I J 1 Fund Value Large Stock Mid Stock Small Stock Intl Stock ST Bonds Mid Bonds LT...

Hi, new here. I'm working on an excel sheet and I came up with such problem: - I would like to have two fields/cells let say A1 and B1 - In A1 I would like to insert a number (no of holes) - In B1 I would like to show "low", "mid", "high" depending on some simple calculation/condition based on...

I have string, S:\Houston JIB Accounting\Outside Operated JIB's\Jacquie's Group JIBs\SOHAIL RIZKI UPLOADS\Cocohills\241005-PHOO2\0817NNJ036241005-SBOO2.xlsm And I need to extract 0817NNJ036241005-SBOO2 here it happens to be the last in this string, I would like to know how to extract this and...

I need to search a text string, find 3 consecutive numbers in a row, then extract the first two characters. I have given an example below. The 3 consecutive numbers will always be between "-" but the occurrence of "-" will vary. The numbers also might be stored as text within the string. The...

Hello I have a string of text of variable length which contains an 8 digit purchase order number which I need to find. However, the format for the PO varies between “PO #”, “PO#” etc. I am able to return the PO number using the following example formulas...

Hi, I am trying to figure out how to implement a regex solution to a data field and was looking for some help. I have got a fair bit done using mid and search/find but I am still doing a lot of clean up to the data after extraction to compensate for the different way people record the same...

I am currently using VLOOKUP with nested MID function. However my look up value sometimes is a number and sometimes is a character. the function i have works for either numbers or character but i can find a way to make it work for either. This is how i have it set up...

Hello I am fairly new to formula in Excel Is is possible to use the MID function to find out if say character 6 is a letter (A,B,C etc) or a numeral (1,2,3,4 etc) in the example below the letter could be any of the 26 letters of the alphabet and numbers could be any 0 - 9 12516VBRAKAK...

I am a complete noob in regards to excel and formulas so any help would be greatly appreciated. I am trying to get a formula to automatically display "Day SHIFT", "SWING SHIFT", or "MID SHIFT depending on the current time. So the time range for "DAY SHIFT" would be 0730 to 1630, "SWING SHIFT"...

Hi I have for example a line of text like this: "abcdef" and I want to vlookup two letters at a time to replace the whole text with something else. I have a lookup table like this in column A and B: ab = 1 cd = 2 de = 3 ef = 4 and so on So function input is this: "abcdef" and output would be...

Hello! I have a problem with formula. I Have two tables. Main and support. Support looks like t <tbody> Symbol Crit FullName One_Some_dn_1_ mas SOME NAME 1 One_Some_dn_11_ mid SOME NAME 2 Lik_mo_ mid SOME NAME 3 oper_nand_ mid SOME NAME 4 oper_nand_ODK_ mas SOME NAME 5...

Hello there I have Excel Sheet which look like multiplication table but the number are my catalog numbers available usage (See table below) I wish to show only the mid numbers (mid 7,3 of the number: 001, 002...) but the full value will stay for other usages <tbody> 0 1 2 3 0 21609500000...

I have the following data: I would like to use sumproduct based on day of the week but also replacing the Hi, Mid and Lo with their correct values. For example, for Paul, the total of his Mondays, should be 1*100+3*1+1*1 Any ideas?

Hello. I am one solid notch above novice, but a quick learner, and was hoping someone could help get me started with a solution. I have a large list of investments that contain various pieces of information (Name, Ticker, Asset Class, Performance data...). The list itself changes frequently...

Need to pull "Mortgage" out of Business Mortgage, Loan. I thought using the mid function would be the correct way to do it, I am not sure because I used the MID function and got it wrong.

I have a cell (E1) with a string of text. I need to extract the batch number from the text string and put it in a seperate cell (D1) The problem I am having is the batch number ie either 7 or 8 characters in lentgh. Here is a sample of the alue in E1: BatchID - BI98C01D XMLExtraction -...

I am trying to use mid with if, I tried nest IF, but that didn't work. I am using the following it work but will not give me the response I need. =LOOKUP(MID(ROOM_NUMBER,2,1)+0,1,"1st Floor") <tbody> ROOM_NUMBER FLOOR <tbody> N1017 </tbody> =LOOKUP(MID(ROOM_NUMBER,2,1)+0,1,"1st Floor")...