vb.net - Formatting data using vb and excel -


this may sound simple, need it.

i using vb create excel file , doing searches text file. have result column (a1 a4) in excel following data:

h'4404 h'5712 h'5129 h'f112 

what need somehow using vb, instruct excel show numbers read backwards i.e following in a1 cell:

404421759215211 

any welcome.

excel vba has vba.strreverse() function possibly simpler vb.net. dotnetperls page shows how replicate function. (there other ways - linq example.)

so need reverse strings, join them create single string, replace h'. replace h' first if prefer.

i think should attempt , you'll able come code if struggle.


Comments

Popular posts from this blog

html5 - What is breaking my page when printing? -

html - Unable to style the color of bullets in a list -

c# - must be a non-abstract type with a public parameterless constructor in redis -