Hello All,

I have a data that comes from the source with some sort
of a weird format. There seems to be a bunch of spaces
before the number. When you look at the value in the
formula bar, you see a gap before the number starts. I
can go in and manually delete the space and the number
becomes usable. Is there some other way to accomplish
this?

I can also use a MID formula then multiply the result by
1 to make the number usable.....I just do not know where
to start the mid. It varies with or by the number of
characters. Any ideas would be greatly appreciated.
Thanks