#alphanumeric

  1. X

    Excel Formula for an alphanumeric text string in a cell

    I'm not really even sure how to query this so I'll provide an example and then explain further: JT005 JT005 BB005 BB005 BD010 These values are pulled in from an agent database. The structure is always a string of 5 characters- the first 2 are alphabetic and correspond to the person's...
  2. H

    Max value of specific entry with alphanumeric prefix

    Hi everyone, I'm new here. Excel is fun it's like a puzzle to me.. However, this one problem I'm having a hard time figuring out.. Kindly help! I need to get the max value of cell with a "9045-0151-ABC1-WXYZ-TO" prefix only. The row may contain blank cells also, please see below...

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
Back
Top