1. S

    Need excel formulae to get first character than all data upto length as 8

    Hi , Want Regex in excel formulae as mention below input and output for reference. Input Output 3005AB1394714000000 AB139471 2022ABR52447FPV ABR52447 2022A9561554PPV A9561554 2022ABR52240LTW ABR52240 2022PAR45939FPV PAR45939 2022PNN03733FPV PNN03733 2019Z6167512 Z6167512...
  2. H

    Extract all number of 6 digits in all records

    Hello! I searched for a while how to fix my problem but none of the solutions works fine, so I come here hoping some new help :) This is an example of string I got in my table : 417720;2;2003;431967;432071;432135;432071;432504;432135;432504;433695 I would like to extract all number of 6...
  3. H

    Extract all number of 6 digits in a string

    Hello everybody! I'm a beginner in PowerQuery and I try to extract all numbers of 6 digits in a string for each of my records. For example, following string I have : 497887;443445;#789788,112456,test;999877;john 788487 From this one, I'd like to extract the following value ...
  4. MartinS

    Loop Using List of RegEx in worksheet

    I have a workbook 'tool' which needs to validate the names given to the files being output. The validation requires that, where the filename starts with 'ABC_', it should be one of a set of known syntaxes, i.e. ABC_2020_[MF]_(#_##%_S#_#_A#_##%_W#%) i.e. ABC_2020_M_(1_50%_S7_5_A0_25%_W1%)...
  5. D

    Regexp help, I need a regex that accept a string of (+) or (-) followed by a number

    I want to write a regular expression in vba that accepts 1,2 or 3 (-) or 1,2 or 3 (+) and series of digits(0-9), and it can repeat so for example +++5+2-10+6 is accepted ++++5 is not accepted because there 4 (+) as well as ----10+2 not accepted because there are 4 (-) I have tried many regex...
  6. P

    Google sheet - Extract images from html

    Hello guys, i have html with images different sizes and i want to select only one with 960 resolution in link, i tried with some formula and it's not working the best in some cases it doesn't extract right, ill share with you spreadsheet with example I have one more question, i have this code...
  7. S

    Replace/Delete a specific pattern within a string using VBA

    Hello, I'm looking for help in locating and replacing/deleting the following pattern within a string in a cell: "" where x represents a numerical character i just learned how to use regExp...but can't figure out for the life of me how to tell it to look for the...
  8. airforceone

    RegEx Row Column Listing Error

    coming from this thread String Parsing I was able to convert @Peter_SSs function code to an ordinary procedure. (thanks again @Peter_SSs ) Sub PetListII() Dim RX As Object, M As Object, RXCtr As Integer Dim K As Integer, ConfisKated As String, FullName As Variant, MaxNumero() As...
  9. O

    insert Regex trick at any step (mid?) Advanced Editor

    Trying to use run the Regex trick (that members Grah and Bo_Ry skillfully adapted for this case), I run into a problem which might have to with my worksheet not being a table. The error text is: Expression.Error: The field 'Comment' of the record wasn't found. Details: Name=Sheet1 Data=...
  10. R

    Find text from repeating sections of text file

    Hi, I want to make a macro to search for repeating blocks of text in a text file. I know how to load the text file to memory but I don't know how to find the repeated text. I've seen examples of searching for text using regular expressions which seems like it might be the way to go, but I...
  11. S

    Why this is not Working?

    Dim MyRegExp As RegExp Set MyRegExp = New RegExp With MyRegExp .Pattern = "(?<=Your message wasn't delivered to )(.*)(?= because)"...
  12. S

    How to make this regex work in Excel?

    Dim MyRegExp As RegExp Set MyRegExp = New RegExp With MyRegExp .Pattern = "(?<=Your message wasn't delivered to )(.*)(?= because)"...
  13. S

    How can I paste the found regex to another column? Getting Invalid procedure call or argument error

    I have been stuck googling for a while now. What I am trying to do is: 1. First check if "mystring" is in column S (s_col) 2. If so, search column P (p_col) for a year that has white space in front and at the end 3. Paste that year into column k (k_col) However I keep getting an error that...
  14. B

    VBA Regex Not Recognizing Pattern

    Hi, I'm working on a program that I want to recognize if a cell contains any number in it by leveraging a RegEx. Currently it isn't working and only returns text when the cell has numbers and text. In the cell I have "55112 5 mile radius" & the cell format is listed as general. Would love any...
  15. D

    Use RegEx to creat in cell fuctions that find substrings and modify them in the string.

    Hi, So I have a list if alphanumeric IDs that I'd like to modify using RegEx to create an in-cell function. I've already enabled Microsoft VBScript Regular Expression 5.5, and I'm using the below code: Function simpleCellRegex(Myrange As Range) As String Set regEx =...
  16. T

    PDF to excel theory

    I've been assign a task where I need to map data from a PDF converted excel file to another exported excel file with pre-determined headers. The goal is to standardized the converted PDF so that the data can be extracted to the exported excel file in vba. One big issue I foresee is that the...
  17. Nelson78

    Regex: hidden "" after a substitution

    Hello everybody. I've a cell assuming different values. For example: 105,32 euro Now, with regex I've removed the non numeric value in order to have 105,32 My code: Dim replacement As Object, trunc As String Set replacement = CreateObject("vbscript.regexp")...
  18. E

    Is it possible to use RegEx in Search and Replace?

    Hello I want to use back references and regex with Search and Replace, is it possible? Thanks!
  19. P

    Highlighting temperatures on cell change

    When the contents of a cell changes, some strings are highlighted. This part I got working already. Now I added a regex to highlight strings that contain a temperature as well (i.e. 13° or 10°-25°) This part however does not work (no error but just no output) This is what I have so far. This...
  20. Caleeco

    Regular Expression TidyUp

    Hello, I have just waded into the world of Regular Expressions. I have created a Function (with some googling) that will check if a pattern exists at the start of a string. The function works as anticipated but Im not sure if this pattern is as clean as it could be? The Pattern is...

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