extract string

  1. 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...
  2. 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...
  3. 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...
  4. 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>...
  5. 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...
  6. 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...
  7. 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...
  8. 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!!!
  9. 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...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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