Thread: RIGHT function
View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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


.