extract data from string

  1. V

    Need to extract information after a certain word IE: "ROOM:"

    Hello, I'm new to this. Could someone help me with a formula i can use to extract to cell the room name/number from a text field. (I have several 100 of these i need to pull out to a separate cell) - ----------------------- Example: ISSUE: PROJECTOR NOT WORKING Additional Info: have tech go...
  2. L

    Extract list of names into individual cells (cannot use 'text to column')

    I have a row of data from B3:B11. Each cell contains a list of names seperated by a comma. To make things more complicated though, the names are grouped by department. For example, the text in B3 looks like this: <tbody> All: John Smith, John Smith, John Smith LOB: John Smith, John Smith...
  3. K

    extract and sum data values beginning with a certain character

    Hi there! I have been racking my brain on how to do this - and I am not sure if it is even possible... here is what I am trying to do: I need to extract all monetary values from the sample text string below that start with the $ character and then sum them together. The character string can...
  4. C

    How to extract "n"th word from a text string

    hello...i'm using excel 2016 and I need the 1st word after the number sequence. How do I accomplish this? My text strings are as follows: 67478_06271_CHILLAXBLACK_ZG13096-06 67478_06271_OFFWEGO_ZG12711-04BOOTIEWI 67478_06271_RUBIE_ZG13574-15STRAPPYW 67478_06271_SPRAYPAINT_LACEDBOOTWITHPLAI...
  5. H

    Locate criteria in a string, pull data +/-5 characters to get price

    I have extracted a rather large XML file. Inside the file was an old method of how I stored my invoices. Here is the string of text that I have: Data sp 199 blah blah blah blah blah 60 cbl blah Door 999 blah blah blah blah 299 sp door 888...
  6. K

    Extract 4 digit year from inconsistent string of text

    First posting here so apologies for anything I miss out. I work in an academic library and I'm trying to profile the collection by year published. The only problem is that the dates for academic journals (which span several years) are inputted manually and therefore are written in an infinite...
  7. D

    Problem setting variable based on partial cell string

    Hi all Sorry I am probably being thick, but I am having a problem setting a variable based on a partial string within a cell. AccountingYear = Trim(Mid("A5", Find("201", "A5", 1), 4)) It is giving me a syntax error which I suspect is due to the find statement. My scenario is I have the...
  8. L

    Extract variable alphanumeric thread from alphanumeric thread

    Hi there, I have a list of part descriptions that I need to extract part numbers from. These part numbers may be purely numeric, alphanumeric, or contain hyphens, underscores or special characters: e.g. <tbody> Descriptions Part numbers Handle #09-ir2135ti #09-ir2135ti D90-330-EX...
  9. C

    Macro to extract numbers from a text string, perform math operations and return numbers back to text string.

    I need to convert commentaries in excel on financial data from dollars to euros every month. Rather than manually calculating and converting the numbers and changing the $ sign to €, is it possible to write a macro that extracts numbers from a text string, multiply the numbers by an exchange...
  10. E

    Extracting unit measures from text strings

    Hi, So I'm scraping data from online stores into an excel sheet and often get cells with the following text: "ACANA ADULT SMALL BREED 2.5KG" I want 2.5 to be taken out of this cell (A1 for example) and moved into the next column (B1), and the unit kg to be moved in the next one yet (C1)...
  11. S

    Extracting Text From a Column

    Hi Guys, I basically have a column of data made up of 0's and names of places. In the column adjacent and to the right of it I wish to return all of the words in the column but not the 0's. If possible I want to be able to return only one of each individual word and then in the cell adjacent...
  12. J

    Split Name String into columns

    How can I extract each word from the following example string using the "" as the delimiter? Example: (A1) John Paul Williams III OR John Paul Williams Split String would look like this: A2: John A3: Paul A4: Williams A5: III OR could be blank
  13. H

    extract Date from string in Cell vba

    I have a cell that contains the following info: Thu, Jan 29, 2015 at 9:33 PM, windyknollgoldens@gmail.com <windyknollgoldens@gmail.com> wrote: The format will always stay the same, the date and email address will change. what I need is to extract only the date from this string and put it into...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top