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

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

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

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

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

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:

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

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

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

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