Thread: Text to Numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seadog2007 Seadog2007 is offline
external usenet poster
 
Posts: 1
Default Text to Numbers

Trying to automatically assign a unique number for varying length (40+/-
char) text fields. For example, "Main Street" might return 54580546, whereas
'Broadway' would return 885213369. Numbers would be the surrogate key for
the text. Application is to document data lineage of data elements in a
database, and need to assign a key to elements so that a parent can be
assigned.

thx