Trim not working

Many thanks, but had tried that with a little, but not complete luck eg, if
the user string was:
sgb test 1 (ie loads of spaces) then
Application.Trim seems to result in:
sgb test 1 (ie one space between each element of the original string)
Is that the intended result?

For my purposes, I'm looking to reduce the user's data string to one
containing no 'spaces' whatsoever.

Regards.

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-245D6D.11162517052005@msnews.microsoft.com...
> VBA's Trim() function, unlike XL's TRIM(), doesn't remove internal
> spaces. Is that's what's not working?
>
> You could try:
>
> UsrName = Application.Trim(.TbUsrName)
>
>
>
> In article <uNnVqNwWFHA.2288@TK2MSFTNGP14.phx.gbl>,
> "Stuart" <sgbooth@totalise.co.uk> wrote:
>
>> Might be useful if I mentioned the required end result(g),
>> namely to remove leading, trailing and intermediate spaces from the
>> string.

Try

usrName=Replace(usrName," ","")

HTH

"Stuart" wrote:

> Many thanks, but had tried that with a little, but not complete luck eg, if
> the user string was:
> sgb test 1 (ie loads of spaces) then
> Application.Trim seems to result in:
> sgb test 1 (ie one space between each element of the original string)
> Is that the intended result?
>
> For my purposes, I'm looking to reduce the user's data string to one
> containing no 'spaces' whatsoever.
>
> Regards.
>
> "JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
> news:jemcgimpsey-245D6D.11162517052005@msnews.microsoft.com...
> > VBA's Trim() function, unlike XL's TRIM(), doesn't remove internal
> > spaces. Is that's what's not working?
> >
> > You could try:
> >
> > UsrName = Application.Trim(.TbUsrName)
> >
> >
> >
> > In article <uNnVqNwWFHA.2288@TK2MSFTNGP14.phx.gbl>,
> > "Stuart" <sgbooth@totalise.co.uk> wrote:
> >
> >> Might be useful if I mentioned the required end result(g),
> >> namely to remove leading, trailing and intermediate spaces from the
> >> string.
>
>
>

Seems the answer. Many thanks.
Regards.

"Toppers" <Toppers@discussions.microsoft.com> wrote in message
news:3A9B4B72-A923-46BF-8C4D-2B9EB1D670D2@microsoft.com...
> Try
>
> usrName=Replace(usrName," ","")
>
> HTH
>
> "Stuart" wrote:
>
>> Many thanks, but had tried that with a little, but not complete luck eg,
>> if
>> the user string was:
>> sgb test 1 (ie loads of spaces) then
>> Application.Trim seems to result in:
>> sgb test 1 (ie one space between each element of the original
>> string)
>> Is that the intended result?
>>
>> For my purposes, I'm looking to reduce the user's data string to one
>> containing no 'spaces' whatsoever.
>>
>> Regards.
>>
>> "JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
>> news:jemcgimpsey-245D6D.11162517052005@msnews.microsoft.com...
>> > VBA's Trim() function, unlike XL's TRIM(), doesn't remove internal
>> > spaces. Is that's what's not working?
>> >
>> > You could try:
>> >
>> > UsrName = Application.Trim(.TbUsrName)
>> >
>> >
>> >
>> > In article <uNnVqNwWFHA.2288@TK2MSFTNGP14.phx.gbl>,
>> > "Stuart" <sgbooth@totalise.co.uk> wrote:
>> >
>> >> Might be useful if I mentioned the required end result(g),
>> >> namely to remove leading, trailing and intermediate spaces from the
>> >> string.
>>
>>
>>