Parsing message body for non-breaking space

I have a vba function that parses an outlook tempate to extract location,
start, end and size details for a permit request. My 'test' contractor has
set up the template and everything works fine with the exception of the size
value. They automatically add signatures to all outgoing mail. Between the
last character entered for size and the start of the signature is a
non-breaking space and a crlf character. I want to be able to use the instr
function to find the phrase 'SIZE: ' the value returned from this function
will be used to calculate the start position of a second instr function that
looks for the non-breaking space (what lies in between is the text I am
interested in). Well thats the theory BUT how do I reference the non-breaking
space?

"John@DerbyUK" <JohnDerbyUK RemoveThis @discussions.microsoft.com> wrote in message
news:2EF678DE-FC6E-4C70-A1B2-5065E3DAF865@microsoft.com...
>I have a vba function that parses an outlook tempate to extract location,
> start, end and size details for a permit request. My 'test' contractor has
> set up the template and everything works fine with the exception of the
> size
> value. They automatically add signatures to all outgoing mail. Between the
> last character entered for size and the start of the signature is a
> non-breaking space and a crlf character. I want to be able to use the
> instr
> function to find the phrase 'SIZE: ' the value returned from this function
> will be used to calculate the start position of a second instr function
> that
> looks for the non-breaking space (what lies in between is the text I am
> interested in). Well thats the theory BUT how do I reference the
> non-breaking
> space?


Chr(160)

That returns a string with a single character in it, it can be concatenated
to whatever else in the usual way.


-Mark