I would like to remove trailing zeros from excel. But when i try to use substitute function i get function not defined error -

-

if use trim replace function mycell.value = trim(replace(mycell.value, chr(160), chr(32))) removes leading zeros.

sub trimtext()     dim mycell range     on error resume next         selection.cells.specialcells(xlcelltypeconstants, 23).select         each mycell in selection.cells             mycell.value = trim(substitute(g7, char(160), " "))         next     on error goto 0 end sub 

sub trimtext()     dim mycell range     on error resume next         selection.cells.specialcells(xlcelltypeconstants, 23).select         each mycell in selection.cells             'range("k:k").select             selection.numberformat = "@"             mycell.value = trim(replace(mycell.value, chr(160), chr(32)))         next     on error goto 0 end sub

Comments

Post a Comment

Popular posts from this blog

Prolog - Listing -

-
i have problem trying work out code here. let's have these codes: university('university of cambridge', 1, 'united kingdom', 90.3, 92.8, 89.4), university('university of oxford', 2, 'united kingdom', 88.9, 94.8, 88.0). how list out names of universities only? tried doing listing. , listing(university). list out or rules. trying names like: university of cambridge university of oxford this gives 1 name: ?: university(x,_,_,_,_). you can query more ; or space to print of them, use fail driven loop: ?: university(x,_,_,_,_), write(x), nl, fail; true.
Read more

python - can't seem to get an output from my class -

-
i can't seem figure out wrong code , why not getting out. can't seem figure out how expand rectangle. instructions: create method called expand takes offset value , returns copy of rectangle expanded offset in directions. >>> r = rectangle(30, 40, 100, 110) >>> print(r) rectangle(30, 40, 100, 110) >>> r1 = r.expand(offset=3) >>> print(r1) rectangle(27, 37, 106, 116) the original rectangle should not modified. >>> print(r) rectangle(30, 40, 100, 110) negative values should return shrunken rectangle. >>> r2 = r.expand(-5) >>> print(r2) rectangle(35, 45, 90, 100) this have far: class rectangle: def __init__(self, initx, inity, initw, inith): self.x = initx self.y = inity self.w = initw self.h = inith def __str__(self): return('rectangle(' + str(self.x) + ',' + str(self.y) + ',' ...
Read more

python - More Issues with overlapping labels in Tkinter -

-
i having problem tkinter. issue follows. i retrieve information database. wish print out based off few user selections. want print out columns a, b, c want print out columns, a, b, c, d want print out columns a, b, d, e also, when query, not know ahead of time how many results have. queries give 1. give 200. print them, this... while x < results.num_rows() : result = results.fetch_row() author = result[0][0] title = result[0][1] conference = result[0][2] year = result[0][3] location = result[0][4] label(root, text=title).grid(row=startrow,column=0,columnspan=5,sticky=w) label(root,text=author).grid(row=startrow,column=6,columnspan=1,sticky=w) label(root,text=year).grid(row=startrow,column=7,columnspan=1,sticky=w) label(root,text=conference).grid(row=startrow,column=8,columnspan=1,sticky=w) ...
Read more