| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Linear Mode
