extract string

  1. Y

    How to input data from a production batch, with a lot of composition

    Hello, I want to input a lot of data from a production batch into Microsoft Excel with version 2019. I want to search for an effective way to do it and to minimize any mistake from inputting at the wrong column, and to make the process a lot faster, because there's a lot of handwritten notes of...
  2. M

    Extract Characters from String

    <tbody> Reference Desired Output Comments 250.75378 75378 Standard reference - without expected suffix i.e. ".000" 250. 75378 75378 Includes erroneous space 250 .75378 75378 Includes erroneous space 250.75378.000 75378 Standard reference (majority of cases) Text Error Text entry should...
  3. S

    Compare data and extract Software name, year and version

    Hi Experts, I was not able to find a thread similar, so starting this thread. I am a novice in excel and I am trying to compare the softwares of an application with the master data list. My questions are as below. 1. I have to compare 2 strings in this scenerio (e.g COL A - microsoft visual...
  4. H

    Extract Numerical Data

    Is there a way to extract numerical data and have it hold its value? I can write a program to extract: 12 pucks, 456 sticks, 7890 fans to 1234567890 123-456-7890 to 1234567890 but here is the actual outcome I am looking for: 123 345 7890 123 345 7890 I would...
  5. L

    Find and extract a substring from a string

    I've been reading around and found all kinds of problems that where like the one I'm having, but none of the solutions worked for me. I have a list with lines liek these: ****** name="email" content="dl-departmentmailbox"> <p><a href="mailto:dl-departmentmailbox">dl-departmentmailbox</a></p>...
  6. F

    Search for specific strings - then highlight cells

    I would like to find cells that contains the string PO (capital letters) on a worksheet and then highlight those cells in a specific color with a macro to be added to the ribbon. It should not highlight cells where the string is part of a word, e.g. CORPORATE. The most likely strings would be...
  7. A

    need to extract number string from text string.

    There is one column that includes all sorts of text and numbers. There isn't a common pattern throughout the column except a 16 number string that I want to extract and place in the next column. I've seen formulas such as...
  8. L

    Search, Extract string, copy part of the cell - HELP!

    I need to code a module in VBA. I'm not sure where to start. I've coded quite a few things, but never something like this. Any help you could provide would be VERY appreciated. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> · The intent is to...
  9. R

    I need help to extract string after a last "-" (hypen/dash)

    I need help to extract string after a last "-" (hypen/dash) abc-454-test abc-test xyz-7847-hgh-test I need test to be extracted from all using an excel formula. Please suggest. Thank you in advance!!!
  10. W

    Extract string starting with ... from a cell

    Hi! I'm trying to write a macro to extract a certain text from a cell. The string in the cell is the following usually: VIFIR - kód :k200010006……. What I need is to extract the 10 digit code from it. but it does not always start at the 14th character and not always with a k. Can start with...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top