ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Auto convert an alphanumeric string (CIS9638S) to numbers only? (https://www.excelbanter.com/excel-worksheet-functions/44148-auto-convert-alphanumeric-string-cis9638s-numbers-only.html)

SDesmond

Auto convert an alphanumeric string (CIS9638S) to numbers only?
 
I have a series of alphanumeric numbers (ex. CIS9638S) that I would like to
automatically convert to a numeric string (ex. 3919963819) that need continue
to be unique values. Is there a script or function that will convert alpha
characters to a numeric representative?


All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com