mid function

  1. A

    Loop through all sheets, use mid function and compare the result if same in all sheets

    I'm trying to use the following two codes I found to work as one task but only the first part works for me. What I'm trying to do is go through all sheets except the one named "WORKDONE" and use mid function to extract some digits from a specific cell to cell I6. That works ok. The problem comes...
  2. E

    Performing a Vlookup in the data sheets having emp. names in reverse order seperated by comma using Vlookup, Mid and find function only

    Hi everyone, <tbody> Can anybody tell me how to Map employee name from column C (in column B) matching exactly the "Resource name" given in column A Using only Vlookup, Mid and find functions. <tbody> </tbody> <tbody> <tbody> Resource Name </tbody> <tbody> Employee Name </tbody>...
  3. S

    How to extract a middle word from a sentence which follows by a particular string(not definite characters but separated by space)

    I am working on a predictive analysis where i have more than 55000 comments, Here i need to extract a broker name which usually followed by a particular string "Client". broker name has indefinite characters. for ex: 1. TCS executed trades for client FIDELITY and since we did not had...
  4. R

    MID Function | Search multiple words

    I need to extract a word between 2 different strings. The first strings starts in any of the following words- LTD, LP, FD or LTD. And it ends before the word "TWO". I'm thinking of using mid function but it can only be used for one argument. Example: I need to extract the following : ASWU...
  5. D

    Excel combining "IF" and "MID" in a formula to pull a specific word.

    Hello everyone I am new to the page and I am in need of some Excel help. What I am trying to do is pull the second word out of a string of text if the first word matches. Here are the examples of the string of text I am working with. eLearning AT3050 9:58am EST (New York...... OBSERVATION...
  6. B

    Extracting variable number of characters after defined number of characters & before defined text value

    I want to extract a product code from an image url. Typical image url: http://s19.postimage.org/h3lmxzcar/RB2132_710.jpg in which the product code is RB2132_710 RB2132_710 has ten characters including the _, other product codes are longer or shorter. However, each image url begins with 35...
  7. T

    Need help with creating a macro that will insert a new column and extract the first value

    I need help with creating a dynamic macro that will insert a new column on the side and extract the first "expected cost" of each "model" and delete the rest of the rows. Below is the part of the dataset that I need to use to create this macro. Here is the example/result that I am looking...
  8. J

    Pulling two digits before a decimal point from adjoining cell

    Hi, I have been trying to figure out how to pull the last two digits before a decimal point from an adjoining cell so those digits show up in the cell next to it with the digits after the decimal displaying as zeros. Cells in A column displays $ABCD.EFG and I want Cells in the B column to...
  9. B

    Excel Abstract Text From Cell (#Value) error

    I am trying to abstract combination of text from a cell (A1). The cell comprise of FirstName, LastName, AccounNumber, and the Statement Date. The formula cannot retrieve name format such as FirstName intial, MiddleName initials, and LastName full (A2). Only works with First and Last names...
  10. F

    how to combine left, right or mid function

    Hi, how can I read/select the number from the string as below: for example: A1: = "Audi A6, Poland - N123323 - SG" A2: = "VW Polo, Denmark - (X) - N233217 CN" A3: = "Ford Fiesta, Italy, XZ, (new) - N876233 - WW" I wan to have only: B1 = 123323 B2 = 233217 B3 = 876233
  11. K

    Extracting time in 3rd COL using Vlookup retrives an error

    I need to extract the characters "to_" from an excel file in which can not be edited. The easy solution would be to do a find and replace on that file but since I can not edit it; I can't use that option. I'm using vLookup to retrieve the values from that excel sheet and when trying to do the...
  12. V

    Need to seperate data of different length in separate columns

    hi, Please help me seperate data after every space, in separate columns. I did see similar queries answered by others but it would be great if you could help me sort the data. For eg, the data mentioned below needs to be separated into separate columns (after every SPACE) <TABLE...
  13. J

    Find Location of a Specific Character in a Cell With Multiple Occurrences of that Character

    I'm using Excel 2007. I'm looking for a way to reference a specific cell to determine the exact location of a specific character that occurs multiple times in the string. In this case I want the numeric location of the last occurrence of the character "-" so I can extract all the text to the...

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