How to remove leading spaces from a VBA string?

[jmccoughlin]

Hi All,

Hopefully an easy one.

Would anyone know how to remove a leading space (only if it exists) in a VBA string?

So if myString=" This is a test" It should be changed to mystring="This is a test"

This needs to be done within a VBA script, and remove the 1st character, only if it happens to be a space.

ps: I found examples using "Trim" online, but the result seems to be exactly the same as the input.

UPDATE: Thanks to Obsessed (below), I learned this string actually had a "breaking-space" instead of a space. His solution is #6 below.

Thanks so much,
jmc