Saturday, 15 March 2014

excel vba - how to keep part of a string using vba -



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