• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Missing Sequences

R

Ranjith M

New Member
Hi,
need help in XL , i have a Sequence of Numbers in Hexa Decimal from 0 to FF in a ROW (A1) , have some data which will show some address as 3A - 3F

i pasted the Address 3A in a Single cell and 3F in a single cell ,

i want an output of 3A 3B 3C 3D 3E 3F in excel

do any one please please help me out to get the formula ,


Note : all the values are Hexa decimal ,
 
Hi ,

When dealing with hexadecimal values , it is better to manipulate decimal numbers and use the functions DEC2HEX and HEX2DEC to convert between the two number systems.

Narayan
 
Hi Ranjith,

DEC2HEX and HEX2DEC both formula are available in excel

DEC to HEX = =DEC2HEX(cellAddress)
HEX to DEC = =HEX2DEC(cellAddress)


Ranjith M said:
can you tell the formula if i want to do the above mentioned operation by using Decimal numbers??
Click to expand...
 
guys , i want to find the Missing Number sequence , not for the convert of HEX to DEC
i have 30 in one cell and 40 in other cell , i want to find the missing number , it have to show 31 32 33 34 35 36 37 38 39 in different cell
 
You must log in or register to reply here.
Back
Top