non-numeric data

  1. J

    Using RANDBETWEEN with Non-Numeric Character strings To Generate a Result

    Cells AE2 thru AH2 have the following characters: AE2: COO1536578 AF2: AFI58491599 AG2: GHU4582154 AH2: UHT7851596 In AB2, I'd like to write a formula similar to the below, which will choose one of these cells at random and populate it in AB2. I currently have a working formula as follows...
  2. D

    Insert space after non-numeric character and a period

    Is there a way to check for a space between a non-number character, a period, and the next non-number character? In other words, I want to check text cells to make sure I don't have something like, "Attain the ridge line at 0.25 miles.Once there, head north." I want Excel to find "miles.Once"...
  3. N

    Isolating non-numeric data in an IF statement

    Isolating non-numeric data in an IF statement <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am trying to run, what I would think is a fairly simply formula, though I am having trouble finding any information on-line. <o:p></o:p> If I have a range of...

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