1. S

    Adding a prefix based on the value of another cell

    Hello All, I need a bit of assistance with adding a prefix to an existing value in a cell based on the value that is in another cell. Here is the scenario. I have a field called Job Type. This field has a dropdown list in it that is coming off of a named range in a second sheet in the same...
  2. L

    Zip series of files with same prefix in the same folder

    Hello. I need help coding to zip files with same prefix in name. Every day, I receive 200 files like these in 1 folder: 1111111111_1321435435_HD_SL.pdf 1111111111_1321435436_HD_SL.pdf 1111111111_1321435437_HD_SL.pdf 2222222222_2542875575_HD_SL.pdf 2222222222_2542875576_HD_SL.pdf I manually...
  3. P

    Delete Prefix in each cell

    Is there any VBA Or Custom Function or Formula which help in removing the prefix numbers and alphabets at the starting of each sentence. AB1RAW DataExpected Output21. TAS Balagopal – Export management – HimalayaTAS Balagopal – Export management – Himalaya32. Varshney & Battacharya –...
  4. L

    Countif formula returning the same results for entire data range that start with a prefix of < >

    Hello! I'm building a dashboard and using “COUNTIF” to simply count the number of times a complaint isowned by a particular person or process… The issue I’m having is new ownershave been added to the data and the begin with < or > for example <over font="" old<="" 5years=""></over>...
  5. Dazzawm

    Help & Advice On A VLookup/Match Maybe?

    I don't really know how to explain this!! I have 2 sheets with a massive amount of data. Sheet 1 will have numbers with a 2 letter prefix then 4 or 5 numbers then letters again, and so will sheet 2. I need to match up ignoring the last letters. Excel...
  6. E

    Scrape web page

    Hi, I am looking for code that would be able to scrape a link like this ? There would be multiple links that it would have to run through that would have the same structure. The prefix would always be...
  7. L

    Return Full Cell Text based on Prefix Lookup

    Hello Everyone, thanks in advance! On Sheet 1 in cell A1, I have a can type a prefix (e.g. "CZ1-1123TRH-2200-") and there is a table on a Sheet 2 wherein Column A includes hundreds of values with several prefixes and multiple suffixes for each that create several "assets" (e.g...
  8. L

    why I am not to copy cells after blanks by using VBA code

    please see exmple below: when I ran my macro its only copy data up to Transection number and not all way to part number and I want all the columns in my break-up files.. I know I messing somewhere and would appreciate the additional help. Thx a lot for your reply. Set rng = cll.Resize(limit...
  9. JLGWhiz

    multiple users with same user name prefix

    Just wondering if anyone knows the story behind the &#x2605 user name prefix. All of the threads that I have viewed that use that prefix seem to be homework type questions and I am hesitant to respond to them. The latter part of the name varfies from thread to thread but the &#x2605 is always...
  10. J

    finding substring from a string with dashes

    I have parts in the following format: <tbody> ABVD-JtU5d-NR393. Where the prefix, base and suffix can be any length., but there are always two dashes. I need to add a column to show the prefix, base, and first letter only of suffix. So for the above part, i want to extract ABVD-JtU5d-N...
  11. dannyok90

    Sequencial VBA ID Number

    Hi all, im sure theres a simple answer to this but im struggling - as usual :D haha the code below inserts a new row and stamps a unique id in cell b using the date and time with a prefix "GO" Rather than stamping the date/time id like it to stamp A00000 then A00001 and so on. If i add a blank...
  12. B

    Unique List Generator Based on Prefix

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody> A B C D 1 List Prefix List 2 N12111 N1 N12111 3 M14999 N12987 4 N12987 N12555 5 A33001 6 N33444 7 N12555 8 A33888 9 10...
  13. Colin Legg

    _bdm. names in Name Manager

    Does anyone know which add-in creates names with a _bdm. prefix? An example: _bdm.8967E1C0A2914A6EB0F4E56B3B28F0A2.edm
  14. F

    Array formula to expand complex list of numbers with same prefix

    I request help to get a very complex output, so it seems a very complex array formula could be needed. My inputs are 2 numbers that share a common prefix. The first number is the common prefix and the second has a few numbers more and I need to get a list expanded up to the second number. This...
  15. F

    Array formula to get longest common prefix

    I have a list of numbers and I want to get the common prefix between them. I've been able to make this array formula that gives me correct output but comparing only 2 numbers (stored as text). A1=23702000000 B1=23702999999...
  16. C

    How to link a Module to a Userform to automate changing.

    <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings>...
  17. D

    VBA set sheet based on sheet Array and Part of Cell Value Array

    Hi, My Code below is so I can get the cell value from the lookup workbook and add it to the Active Workbook if both cells values are the same What I would like to do is match part of a cell value to a sheet name and set that sheet as the look up sheet. Each part of a cell value will vary but...
  18. D

    Programatically add prefix to all named ranges

    In my workbook I have many named ranges. I want to add a prefix "P_" to each name. Is there a way I can do this with VBA to save time? Thanks
  19. X

    Macro adding language codes to the names of packages

    Hello, I need a macro, which would go inside every zip package, remember the name of language folder inside and add that name to the beginning of package's name. Example: I have many packages in location: c:\Desktop\packages\ The packages' actual names look like this...
  20. C

    Longest Prefix Match for Phone Numbers

    Hi all, This is a problem I've been grapping with for a few months on and off and I can't seem to crack it... I have a CSV list of call detail records and a list of long distance rates and I need to be able to match the rate to the phone number based on the longest prefix match. Here 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