RIGHT function

  • Thread starter Thread starter David
  • Start date Start date
D

David

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
 
A1: EndOfLine=Dword:0000004
B1: =LEFT(A1,FIND("=",A1)-1)
C1: =RIGHT(A1)

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy all text in a string prior to the last period... 1
Newbie - Macro Help 1
Recursive Functions in Excel? 6
Index function 1
Excel 2007 VBA: Convert laaaaarge number to Hex 27
Function to Insert Text Into a Formula 3
Excel help separating / 2
Task Scheduler Service broken in Windows XP Professional SP2 3

Back
Top