extracted

  1. T

    Pivot Table Extract

    We have a complex Pivot Table housing our GL data. From the Pivot Table, the user can double click any category value to create a new sheet that contains the records that total the value reported in the Pivot Table cell. My question: Is it possible to "refresh" the extracted data...
  2. E

    Extracting Text in Cell

    Hi, I know how to extract text between special characters but my question has a little wrinkle. I have text that looks like the following: 253>9374 734>3949;3948>3448 3847;43548>3949 589 I want to extract the text to the right of the ">". There could be multiple strings in each cell to be...
  3. M

    Excel Trick 185 Quirk

    I've been using the formula for quite some time now with much success but this one got me stumped doing this project. 50% of the columns gets extracted correctly but the other I get "#REF!". The data source is from the same table, using the same headers. Any guesses why?
  4. B

    Extract Email Address

    I am trying to extract email address from columns and display them in another column. The way the information is extracted causes the email address to appear in columns. Example: A
  5. K

    Extracting text using VBA

    I have made some head and thanks to everyone's help so far. I am using the same string of text:' MECH~CDA-CUP-PF~1 - CUP0915.2XL - Copper Reducer (P) How do I get the CDA-CUP-PF extracted using something like this? AddFormula TopLeft.Offset(1, 3).Resize(RowCount, 1), "=LEFT(AA" & Row &...
  6. H

    format value in code

    I have the following code below which I need amended to format the value extracted from B1 for eg as $ 415,250.75 ("$#,##0.00") the value is extracted using VBA but not formatted asrequired above strBody = strBody & "Those over 60 days amount to " & Sheets(4).Range("B1") & " vbNewLine &...
  7. M

    extract text from an entire string

    Excel experts, I have checked other posts related to extracting text, but I am not able to understand how I can implement that to my needs. In column A, I have 2,000 rows of the text string that resembles the following: "07/16 07/14 1234 WM SUPERCENTER #1234 HOUSTON TX $5.99" A) The first...
  8. A

    Management Tool help

    Hi This may get complicated so please be patient with me. A management tool was developed to track staff performance. There are three tabs that my administrator will paste information into which is extracted from our different onlinr management systems. There is a tab that automatically...
  9. T

    MATCH or VLOOKUP? or something different

    I have some extracted data into excel as a csv file and it contains lots of information, but I'm focused on the Alias. Then I have a list of usernames that has been given to me. What I would like to do is, if the alias/name match, export (extract) all of the data for that alias to a new...
  10. A

    Split adresses

    Hi, I have some addresses that need to be split into three different cells: Adress, Zip, and City. I tried =TRIM(LEFT(SUBSTITUTE(D2;",";REPT(" ";LEN(D2)));LEN(D2))) to get the address, worked fine for those with the form: xyzroad 16A, 1400 townXYZ. But when I have it in the form XYZ, XYZroad 18...
  11. M

    Extract numbers from series.

    Hello, Extract number from string B, conditions is after 3 & 1, and put them in column D In the column A just crosses are shown which numbers to be extracted from column B Like this example <tbody> Nºs After 3-1 3 1 1 3...
  12. L

    Don't know where to start...VBA gmail

    G'day guys... New project came up and I'm clueless where to start on this one. The idea is simple enough, emails will hit Sales@inbox.com.au which will go into a pool of sales inquiries. When someone hits a button, they will get the oldest/or newest email extracted to a dashboard or excel as...
  13. H

    macro to extract certain Criteria

    I have data in Col A and B on sheet "Imported Data" I only want to extract the following Types to be extracted Currently only DV Col A and M1 Col B is being extracted I also need NV and RE to be extracted It would be appreciated if someone could assist me Col A Col B DV M1 NV RE...

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