extract data from string

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...

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...

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...

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...

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...

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...

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...

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...

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...

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)...

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...

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

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...