Home |
Search |
Today's Posts |
#1
|
|||
|
|||
RIGHT function
I just used a right function to select data from a cell. All OK, except it
copied the selected data to a new location but did not remove it to the new location. Would someone help me extract the last digit of the hex value to a adjacent cell and remove "=Dword:0000000", here is the original string taken from a registry file: EndOfLine=Dword:0000004 and end up with (say) A1= EndOfLine B2= 4 The string "EndOfLine" is of course quite variable, only the =Dword:0000000 is constant with a changing last vaule for the Hex number. Many Thanks David |
#2
|
|||
|
|||
A1: EndOfLine=Dword:0000004
B1: =LEFT(A1,FIND("=",A1)-1) C1: =RIGHT(A1) HTH Jason Atlanta, GA -----Original Message----- I just used a right function to select data from a cell. All OK, except it copied the selected data to a new location but did not remove it to the new location. Would someone help me extract the last digit of the hex value to a adjacent cell and remove "=Dword:0000000", here is the original string taken from a registry file: EndOfLine=Dword:0000004 and end up with (say) A1= EndOfLine B2= 4 The string "EndOfLine" is of course quite variable, only the =Dword:0000000 is constant with a changing last vaule for the Hex number. Many Thanks David . |
#3
|
|||
|
|||
Are your values never more than a single digit?
On Fri, 19 Nov 2004 22:03:46 +1000, "David" wrote: I just used a right function to select data from a cell. All OK, except it copied the selected data to a new location but did not remove it to the new location. Would someone help me extract the last digit of the hex value to a adjacent cell and remove "=Dword:0000000", here is the original string taken from a registry file: EndOfLine=Dword:0000004 and end up with (say) A1= EndOfLine B2= 4 The string "EndOfLine" is of course quite variable, only the =Dword:0000000 is constant with a changing last vaule for the Hex number. Many Thanks David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
how to move user defined function | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |