Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert text strings to a code or number
In column A and B I have text representing an Entity and its Intercompany,
respectively. In column C I have concatenated the two. So now in Column C, for example, I have "BillTom" in row 1 and "TomBill" in row 900. I need Excel to convert the text into some sort of code, ASCII or number that shows they are EQUAL. I need something that shows "TomBill" and "BillTom" are the same thing, just in a different order. I cannot build an IF formula or use Find/Replace, as I will have thousands of these types of combinations. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert text to number for a range of data in a column | Excel Discussion (Misc queries) | |||
convert number to text in Spanish Language | Excel Worksheet Functions | |||
convert number to text and format it. | Excel Worksheet Functions | |||
convert number to text and format it. | Excel Worksheet Functions | |||
convert number into corrseponding text | Excel Discussion (Misc queries) |