Why is that site not helpfull. It explains all string manipulation functions and you just have to go through it and pick the one you think will work.
There are many options, but you are not being clear on what you want. First you said you wanted to use the mid function to
left of the % and I nee to trim off the O and 1 space so I am only left with the #'s
The mid function example I provided would result in only the numbers being left "10.0"!
Then you are saying you want
everything from the left of the %
You could use the mid function or the left function or a combination of instr and left function or...!
Now you are saying you just want:
end up with 10 in it
So again something else and again you could just easily use the mid function!