Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
[[ This message was both posted and mailed: see
the "To," "Cc," and "Newsgroups" headers for details. ]] I have the following data: 00000000000976042B 00000000000637707{ 00000000000016326{ 00000000000047546F 00000000001484392E 00000000000687370E 00000000000958500{ 00000000000771160{ 00000000004424795A The last character of each row requires translation as follows: {=0 A=1 B=2 C=3 D=4 E=5 F=6 G=7 H=8 I=9 I'm able to translate the 18th character by using the replace function but would like a less manual process. I'm a bit outside the box at the moment and not sure to go from here. Could sure use some help! Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Replacing certain characters in a cell | Excel Worksheet Functions | |||
Replacing ascii characters | Excel Worksheet Functions | |||
Replacing specific characters | Excel Discussion (Misc queries) | |||
Replacing specific characters with spaces | Excel Worksheet Functions | |||
Replacing characters | Excel Worksheet Functions |