mid fuction

Hi, I'm wondering how best to approach this... The formula I have in I2 is: =IF(RIGHT(H2,5)="00000",IF(ISERROR(MID(F2,FIND("LOCDIFF",F2)+9,FIND(":",F2,FIND("LOCDIFF",F2))-FIND("LOCDIFF",F2)-12)),H2,MID(F2,FIND("LOCDIFF",F2)+9,FIND(":",F2,FIND("LOCDIFF",F2))-FIND("LOCDIFF",F2)-12)),"")...

I am working with 2 Sheets in a workbook. I am attempting to run a PARTIAL MATCH from SHEET1, COLUMN C to SHEET2, COLUMN A. When there is a match of 5 digits, I want the value in SHEET2, Column B in the same row as the match, to be placed in COLUMN G of the row matching SHEET1, Column C. I...

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.

Hi everyone, I like to extract middle text string from the cell, how can I do that? For example: (loop:"LITTLE") (loop:"ABCDEFGH") (loop:"TINY") (loop:"BIG") In the formula cell, I want to see : Little ABCDEFG TINY BIG Please advised and your help will much appreciated. THANKS

Hi everyone, I am new to excel, I am trying to extract middle text from the cell. For example: ("111111") ("222") ("5555") I want return : 111111 222 555 Please advised!

Hi, I am currently trying to import data from a website so that whenever I open up my spreadsheet it automatically updates my data to cut down on some of the time I spend importing each day. I have an imported web query but the data does not populate into tables like it is in the website it...

Hi, in column A I have email address: pawel.tom@gmail.com aqwe_12@yzf.pl audi_adm_2@audi.com In column B I want to get only: gmail yzf audi How can I do it?

Hi all. I'm using excel2010. I've been searching the posts for a solution and everyhting always seems to be in reverse of what i need. I have text strings of varying length and are all unique. All i want to do is keep the first 24 characters and the last 7 characters (=31 so i can name the...

I have a string it is LF_LCA_079_010813_Curved_1_4_Short it reads into vba from a file and is give the variable name LFDesc and dim LFDesc as string Now i would like to pull LCA_079 from that string and create a new string with this text. I can do it in excel using the MID and Find functions...