extract content

  1. S

    Excel VBA to extract 2 or 3 keywords left and right from cell content

    Hi Friends, Trying to extract 2 or 3 keywords from cell content through excel vba. Sheet1 ColumnA has rows with content sample file attached. I need vba to search for keywords from sheet2 ColumnA in Sheet1 and extract 2 or 3 or 4 keywords from each row content into sheet3.(Popup box would be...
  2. A

    Compare two workbook column and pull data from one work book to other

    I have two workbooks M.xlsx and Lable DB.xlsm. I need VBA to compare this two workbook column A which has matching values, and when values are matched copy the corresponding Col B and Col C datas from Lable DB.xlsm to the matched value of M.xlsx workbook. Some condition: I will place both...
  3. S

    Extracting variable length data from cell

    Would like a formula which would extract the contents between the word circuit and the second comma in a string: MPLS - MPLS Services, Circuit 2083676, Verizon, xxxx,,xxxxxxxxxxxxx , xx MPLS - MPLS Services, Circuit 572222DAT1, xxxx,xxxxx,xxxxx
  4. M

    extracting words from a cell

    Hi I've got a csv file with dozens of column titles in one cell. Please find below the first 4 column titles, to give you an example of the data. Sales_metric|Volume_metric|Promo_id|Zone_id| Does anyone know how to extract the into separate columns so "Sales_Metric" would appear in one...
  5. F

    Extracting Data From Multiple Sheets into 1 Sheet

    I'm working with multiple worksheets in one workbook and want to find a way to extract data from the multiple tabs into one sheet. Each tab has different headers, see below. I only want to pull out certain data. Each worksheet would be updated weekly. TAB 1 HEADERS: <tbody> Shoot Date Air...
  6. E

    extract text between quotations

    Hi excel gurus, Would it be possible to extract the values between quotations? <tbody> identifier="key" key="Maximal-Leistung" name="Maximal-Leistung" </tbody> so that the output shows the Key value i.e. Maximal-Leistung Please can someone help :confused:
  7. L

    Extract numbers from a string

    Hi everyone I want to extract all the numbers from a string and get them separated by columns or at least separated by comma for example the person left the cellphone 45213204456, job 3489334 house 9888234 mother 452103210, value to pay $25 result <tbody> 45213204456 3489334 9888234...
  8. A

    Need to extract text between dashes (more than two)

    <tbody> TEXT STRING RESULT WOW - WORD - LOVE - NF - CARD WORD JOB - EXCEL - LOL - NL - COOL EXCEL THUMB - OFFICE - ROFL - GR - AWESOME OFFICE </tbody> In above example you can see string I've and result I want. Please help, I want to extract second word between 1st and 2nd dashes.
  9. C

    Extra data from pivot table to new sheet

    I'm self taught and still learning, so please excuse my ignorance. I can create the code I need, but struggle when it comes to variables. I have a pivot table that lists the error codes from my main records sheet and then gives the count for each error code. A pretty simple pivot table. This...
  10. C

    Extract string of numbers

    Hello all, I want to extract numbers using ONLY formula not text to column as follows: <tbody> 1,2,12,14,15 3,5,6,10,18,22 8,17,32,45 </tbody> I have either 1 or 2 digit numbers not more. I tried Left, mid, and right with find and substitute using columns as 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