1. Emanuele

    Multiple column and String extract VBA

    Hi guys, I would like to know if there is a way to add more than 1 adjacent column for the presented code that Fluff helped me to modify in this Post Furthermore it's possible to apply a string extract (for example, extract the first 4 and the last 4 characters and put them in different column)...
  2. A

    Extract Multiple text that contains - in a Single cell to individual cells

    Hello, this is my 1st post so please go gentle on me if this question has already been asked. I've search and found some similarities with extracting an email but unable to adapt what I've found with what I need so hopefully someone can help. What I would like to do is to extract multiple text...
  3. R

    Search and return matches into multiple columns

    Hi All I have a scenario where I'm attempting to extract certain words that appear between double quotes but only if they meet a certain condition. For example I want to search for ALL fruit in column A and present these individually in the subsequent columns. Fruit' = "Pear" OR 'Fruit' =...
  4. R

    Extracting PARTIAL words from cell

    I'm in a worksheet and trying to extract the words after the 3rd and 4th hyphens when they're available in column A (see table below for representation). <tbody> Digital - workbook - sheet Digital - workbook - app Digital - workbook - test Digital - workbook - sheet - max - version1...
  5. S

    Advanced Filter query - What are the rules with editing the extract?

    Previously, I have done an Advanced Filter query, with the Extract in the same Workbook, and: 1.) Sorted the Extract 2.) Made some changes to the Extract Sometimes this had a bad effect: With whatever change I made, it did the same thing to the rows above and below it - unwanted changes Other...
  6. A

    Extracting some data from a string in a cell

    One more help needed. In one column i have multiple email addresses of different length. For eg: amit.dhamija@rediffmail.com. How can i extract value after "@" and before "." which in this case is "rediffmail" ??
  7. T

    Extracting certain data from a worksheet

    I am trying to figure out the best way to only extract certain data from a download from our rating system. Below is an example of how the data is downloaded from the system VEH 1 - 2000 INTERNATIONAL 4000 4900 STRAIGHT TRUCK {1HTSDAAN7YH256306} City State Territory Stated Amount Cost...
  8. K

    Extract 9 matches and continue extracting next 9

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I have 9 unique patterns in the cells C4:K4 and some results in the cells D6:J44, My request is I need a macro which can extract 9 unique matches from the results and copy them in to N4:T44, </SPAN></SPAN> Start looking in the first result row...
  9. N

    Imported data into new table? (totally lost)

    Hello! I have a importsheet with data and need to extract and count several things from it, but I have no idea how or where to start (usually I only used Excel for math problem). I made an exampelsheet with some fake imported data and the right nr of columns, the real importsheet contains...
  10. R

    Auto Filter Pivot table

    I have file that on a monthly basis I dump an extract into. That extract feeds pivot tables on 3 other sheets displaying the information at varying levels of detail. I already have a VBA to auto refresh the tables when new information is added but I'd really like one that could auto filter the...
  11. H

    The extract range has a miising or invalid field name

    I borrowed some code that was in a worksheet that the people that came before me created... I have adapted it to work for me in another situation but I am wanting to modify it. Basically I have a data collection machine that creates csv files with information. I am wanting to extract...
  12. M

    Extract and arrange the numbers small to larger values

    Hello,</SPAN></SPAN> I need to extract the numbers of column E:N and need to arrange them in order small to larger values in the columns P:Y</SPAN></SPAN> Example <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse...
  13. smide

    VBA to extract part of HTML code

    Hello. In cell A1 I'm receiving Customer names an their home town in form of huge HTML code. I need to extract Customer names in column A (A3:A600) and their home towns in column B (B3:B600). Part of HTML code for names is always the same: <div class="customName--1gBeC">J. Jones</div> Part...
  14. Penguinducky

    Extracting City and State from a cell without commas

    Trying to extract the City and State from a cell that has the Name of the Company, City and State in it and I only want to show the location. Problem scenarios I'm having: City and State are mushed together (example: MissssaugaOntario) Company name and city have a / or - between them (example...
  15. spencer_time

    Two numbers to left of * and two numbers to right of *

    Hello, I -had- part of my program working until I realized that the length of the filename wasn't always constant and I need help fixing that. In the following section of code it used to look for a sheet names *CEQ* and extract the two numbers before CEQ and the two numbers after CEQ. I then...
  16. S

    How to extract and cross match multiple occurences with Excel VBA

    Hi Friends, From past 2 days I been trying to extract multiple occurrences present in "cell text"(sheet1 ColumnA:A) and extract into sheet2 and sheet3. Cross match with IDs between sheet2 data with sheet3 and extract matched data into sheet4(Macro 3 final results). I have attached sample data...
  17. H

    Formula to extract characters from text string

    Hi mrexcel forum, Could you please suggest a formula to help me with this issue? Issue A: I will like to extract out the numbers immediately before and after the dot. This is the volume information. Issue B: I will like to extract the 3 characters immediately after the Volume information...
  18. M

    Extracting data from website search bar using VBA

    Hi everyone, I am trying to extract data from a website using VBA. This is the web site: https://gmsip.com.pa But i can not add my range of data to search bar is there any solution to this problem ? no i want to add IMO numbers for ship in the excel sheet and VBA run them in website and...
  19. K

    Extract list of non-zero cell values from a list AND whether Estimate or Actual AND the name of the product

    I have a list that I need to remove the zero value items from via formula to create a new list (imagine an order form). Because people will be using this second form without much excel knowledge, I need it 100% formula driven. <colgroup><col><col><col></colgroup><tbody> Qty Item Estimate...
  20. L

    Extract value between text and character

    Hello, I need to extract the route number, which can be between 1 to 3 digits, see example below: Route 1-1 South Route 26-7 Ludlam Route 29-2 West Route A 101-1 North As you can see the Route value and (-) dash character are constant. Is there a formula in excel and/or PowerBi I can use...

Some videos you may like

This Week's Hot Topics