HI you can try the following formula Iam sure it will work
you can substitute the RowColumn info for a variable it
will work the same, keep in mind those parenthesis are very
tricky PAY STRICT attention to them

=(TRUNC(C12)&(RIGHT((TRIM(C12)),(LEN(TRIM(C12))- FIND(".",
(TRIM(C12)))))))
-----Original Message-----
How can I transform this:

myVar = " 7.200" 'spaces are there

to

myNewVar = "7200"

Thanks
Tom


.