left function

  1. C

    Version Compatibility 2007 <-> 2010 - REALLY?!?!?!

    Ok, so I have an access 2010 database (accdb) I'm using as a front end to pull data from a mysql server and an oracle server (linked tables). I build queries and reports for a user who will run reports from this database who has access 2007. I have 2010. I have a reasonably straightforward...
  2. G

    How to separate variable strings to different cells

    I have a spreadsheet with almost 5000 rows that was imported from a text document into one column. I would like to separate different parts of this column into new columns. Unfortunately, it is a mixture of variable length fields. Certain sections are consistent, others are not. Can you...
  3. C

    parsing apart codes with differing lengths

    I have a list of numbers 0010001 0090001 10001 0110001 020001 I need to split these apart with the last four digits being in one column and the rest in another. example: column B column C 001 0001 009 0001 1...
  4. L

    Can assign a parameter to a variable?

    I have a funtion like: =IF(LEFT(A3,1)="A",1000,IF(LEFT(A3,1)="B",2000,IF(LEFT(A3,1)="C",3000,4000))) In this formula, LEFT(A3,1) appear three times and excel will run LEFT funtion three times. Can use like this? =IF(LEFT(A3,1) AS X="A",1000, IF(X)="B",2000,IF(X)="C",3000,4000))) Thanks. I...
  5. P

    Sumif(Left( Function

    I need to do a sumif based on the first 3 numbers for both the range and the criteria. The 1st 3 numbers in the range column (Column A), the 1st 3 numbers in B1. The easiest way would be to create a whole new column and run a =Left(A1,3) and copy that down and make that my new "range" column...
  6. C

    trying to capture everything LEFT of the second space

    Assume my data is in column A. A bunch of names, varying in length. I want to use a LEFT function in column B, but I want it to capture everything left of the second space. Thanks clint
  7. 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...
  8. G

    Index Match with Left function?

    hoping someone might be able to help? trying to copy a value from one sheet to another with the following criteria: -if the first 6 numbers of the SKU on Sheet 1 matches the SKU on Sheet 2, copy the Price on Sheet 2 to Sheet 1. I used the following formula but it returns an N/A value...
  9. ncjefffl

    Formula to pull values in a specific position WITHIN a cell?

    I need a formula that will look in a cell and give me a certain substring of whatever data is in there. I'd like to write, =Substring(Left(A1,8,2)), meaning start at the far left of cell A1, move over 8 "spaces", and give me whatever is in the 8th and 9th space. Of course, I can't write it...
  10. C

    Finding Text Between Two Instances

    Hi Everyone, I am trying to figure out how to return the text between two different instances of the same symbol. For example, I have this in a cell: 100% Cotton / 55.0 in / 3.2 oz/sq yd / 120 x 70 / 40 NE x 40 NE / Yarn Dye I want to be able to to extract all the information between the fifth...
  11. D

    Using Countif with wildcard and the Left function to pull out strings

    I am a VBA novice and I would greatly appreciate some help please as this is driving me mad<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have a macro (below FIRSTSUB) which works okay. What it does is identify if a cell in Col 1 contains...
  12. C

    Left Function using activecell.offset

    Hello: I am attempting to separate the contents of a column of cells using the "left" function. Specifically, I have a column of data such as "2Q 2010" that I need to split into a column for the quarter and a column for the year. I have constructed a Do...While loop to perform this function as...
  13. J

    Converting text to numeric value

    I am using a formula which is returning info as a text but I want to use the data as a number. The formula is: =LEFT(E2,FIND("-",E2)-1) I am adding this and am getting a circular reference error. What am I doing wrong? =VALUE(LEFT(E2,FIND("-",E2)-1),G2)
  14. B

    Extract Hour Only from HH:MM

    Hi, Trying to extract the HH from a cell containg HH:MM for example if B1 has 10:19 in, i would like C1 to show 10, or even 10:00 would suffice. i have tried =LEFT(B1,2) this returns 0. =LEFT(B1,2) returns 0.4 strangely enough I guess theres an issue because the cell is formatted as...

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