extract text

Hi, I have below sample table that I'm trying to extract the text between the two hyphens in Chain 2, and text after the 2nd hyphen in Chain 3. Can anyone help with formulas? ABCDEFGH1Exptected Results2Dimension valueChain 01Chain 02Chain 03Chain 01Chain 02Chain 033John AJohn AJohn A4John...

I am working to organize a contact list, by using the email id as a reference point to extract the name (first & last) with the company name and set a unique serial number for each company name. I found some valuable formulas to achieve the attached design. However, it requires specifying a...

This question is very similar to a few others, but differs just enough that it warranted its own thread. I have a list of addresses like this: 1234 S Blackhawk Way, AURORA CO 80015- 1234 S Monaco Street, DENVER CO 80237 1234 E Girard Place, ENGLEWOOD CO 80112 1234 W Burgundy Avenue APT 301...

Trying to extract a question from a string of free form text in Excel. Expected Result: How many licks to the center of a tootsie roll pop? Side question, what if there are multiple? Example: This is a test of what I am looking for. How many licks to the center of a tootsie roll pop...

I have this report that I download and export from my ERP system into Excel. I have a column with the name and address in one cell on multiple lines. The name is in line 1. The problem I am having is that the name is repeated on the first line from some of the rows. I want the unique text from...

hi I would like to extract the following words from bank statements that are in a cell: GIRO BANK RAIFFEISEN SCHWEIZ GENOSSENSCHAFT DORFSTRASSE 99 999999 ALIGDNSLIW CH9812349000003109099 Beatrice Tester Bernstrasse 99 1234 Bern SENDER REFERENCE From here I would have to extract "Beatrice...

Hello, I have a cell containing the following information: "AM,1,10|LA,1,5|VU,1,5" The end product i need is one column containg AM (so after" and before , ) one column containing LA (so between | | ) one column containing VU (after | and before ") I need this to be a formula as the codes...

So I am dealing with a big project, trying to tear apart written MD orders for reporting. I have hundreds of patients and pull a very long dense report and figured out some of the keys to make it bite size. Take for example the following: right now I am trying to strip out the "50 mg". I've...

While this is not being implemented within Excel, it does involve the use of strings similar to those used within Excel and I am hopeful someone can assist. I am working on trying to create a template letter that uses bookmarks to generate a UserForm and then selections on the UserForm are...

Hi Masters Could you please help me on issue below ? I need a formula to get "Result 1" and "Result 2", as follow: Result 1: I need to extract just part of text as shown Result 2: I need to get as result only a row that have the same letters from the range Int1 ~ Int5 (empty/blank cells should...

I could REALLY do with some help, as I cannot find an online answer to this question. I am extracting text from a large chunk of text in a cell, and most of it is pretty simple. However, the one bit of text I need to extract occurs in a section of the cell where symbols and suchlike vary too...

Hi, I have been trying to extract only numbers in the next row. actual result as follow: The result I want is <tbody> abc125 125 bcd121 121 111aaa 111 </tbody> While the code works as: <colgroup><col><col></colgroup><tbody> abc125 125 bcd121 125121 111aaa 125121111...

Hi All, I have my text data as below mentioned & i need to extract data <tbody> <tbody> 152/C Ist FLOOR, ASAMBU ROAD, VADASERRY, NAGERCOIL,629001,TAMIL NADU </tbody> <tbody> 21-37-L, I FLOOR, VASANTHAM MAIN ROAD, THUCKALAY,629175,TAMIL NADU </tbody> <tbody> MAIN ROAD, BALAPALLAM...

I have thousands of emails that i need to index by the typical header fields: To, From, Sent, Cc, Bcc, Subject and Date. They're all in Excel, I need some help creating columns next to each email header. The columns will correspond to the header fields. The text must be extracted from the...

Hi there, I'm trying to split all URLs within a cell - the cell contains a mixture of text and different URLs - and extract them to adjacent cells. I have been able to separate single URLs to an adjacent cell, but only up to the first instance of a unique URL - I'm just not sure how to create...

Hi guys i have added a link to a spreadsheet. It has 2 columns in it. I want to extract particular information from within the load of code in that field. The information i want to extract is in the second link. Could you put the data between those characters and put it in cell C2...

First thank you for the assistance. What I am trying to do if possible is pull individual peices of text from a single text field that is imported from a web page. This is what it looks like: How to Setup External Telnet or SSH Client ( 2 ) [Wiki] (21) This is what I am trying to accomplish...

Hi, I've spent months trying to research a solution to my problem and after reading another post from your site that was very helpful for a different issue, I thought maybe you can help me. In A2, there are a list of headers followed by descriptions, one-after-the-other. For example, I have...

Have simple formulas using named ranges to copy down column and would like to replace the last four digits in the named range based on the last four digits in the cell to the left rather than manually changing the year in the named range: Cells to left: FYE2006...

Hi, I am trying to extract the nth word (last name) from a cell following a unique combination of characters (ID #-). I do not want to use VBA, only functions. I need to extract the last name out of each cell which follows 'ID #-', which is not the first name, but the second name after the 'ID...