Hi,
VBA code.
Dim sh_cost_txt As String (or tried As Variant, but doesn't work either....)
Pick up the value from a field with string manipulation functions and assign it to sh_cost_txt, now it's value is "1 200" (including a space within)
Would like to have it without the space, so using the replace() funcion:
replace(sh_cost_txt, " ", "") but it displays: "1 200" in the immediate window, which means it did not replaced the space character with an empty character.
When asking:
?replace("1 200"," ","")
it correctly says:
1200
When asking:
?replace(sh_cost_txt," ","")
it says:
1 200
..... WHY????
Please help.
Thanks,
Peter