excel vba - how to keep part of a string using vba -
i have next cell values
158,4437 159,5656 160,8521
now want maintain cell values till 2 positions after ,
like
158,44 159,56 160,85
can please help me this
try like:
const stest = "158,4437" dim soutput : soutput = left(stest, instr(stest, ",")+2)
vba excel-vba
No comments:
Post a Comment