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.
>>
>>
>>