Use Regex Expression


I have an excel file that contains lines contain a string: Designation Value Price.
What I want is to write a regular expression that will seek to retrieve the first two or three letters of each word. line by line
For example: desig val pri.

as soon as it finishes it must search in a new file the corespendence.

I remain at your disposal for any other information.


Best regards,

@ifranity Can couple of lines of sample data and ur expected output?

1 Like

Try this:


1 Like

Thanks buddy for the quick answer
please find attach the files DesignationClient.xlsx (8.8 KB)
DesignationVDR.xlsx (18.3 KB)
Output.xlsx (7.8 KB)
If match display all the rows from File DesignationVDR.

Thanks a lot,
best regards,