i try to add some strings together using the syntax: string1 & string2
however, there are always space inbetween them. e.g. string1=abcd string2=efg
string1 &string2 always give me "abcd efg" instead of "abcdefg"
any idea how can i get rid of the space?
Try
=Trim(string1)&Trim(string2)
I suspect there may be a trailing space on your first string , and possibly the second string.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi!
It looks like there is a leading or/and trailing space in (at least) one of the strings.
You can use Trim to get rid of leading trailing space. There is worksheet function Trim and also VBA functions TRim, LTrim and RTrim.
Buran
If you are pleased with a member's answer then use the Star icon to rate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks