Concatenating a String and an Integer in VBA Solved

Question

Hello,

When I write:
a = "B" & Str(8)
b = "B" + Str(8)

I get: a -> "B 8" and b -> "B 8"
However, I would like to obtain "B8" without the space.

In my code, I need to generate strings of the form "Bi" where i is an integer.

I don’t understand where that damn space comes from.
Do you have any idea?

ccm81 · Accepted Answer

Hello  if a is of type string then a = "B" & 8 is correct Note: you can always remove the space with a = "B" & trim(str(8)), but why make it so complicated best wishes

Christof422 · Answer

try a="B" & 8 or a="B" + 8  Otherwise put your 8 in a variable  variable=8  a="B"&variable -- The first step towards the solution is research. Our friend Google surely knows the answer...

ccm81 · Answer

re
a little surprised by the error on a = "B" & i
could you provide the complete code of the instruction group where this line is included as well as the declaration of the variables a and i
have a good continuation

Concatenating a String and an Integer in VBA

3 answers

Google maps does not recognize my current location [pc]

How to plug a usb cord into a tv

Cc how to unlock the encrypted channels on my tnt tv

All interfaces blocked.

My account is hacked, i want to recover it

Mouse, fullscreen mode

Pin gmail to the taskbar

Cannot connect to wi-fi

Microsoft extended windows 10 support until the end of 2027

G502 x mouse does not charge on powerplay