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
.
|