Convert integer to String

[rkcim]

I have an integer and I converted it to a string

Here is a basic example of my problem:
Dim i As Integer
i = 5
MyString = str(i)

Now MyString = " 5"
It has a space in front of the 5. How do get rid of it? Is there a better function than str?

 

[rkcim]

Ok this one should be easy rkcim:

Dim i As Integer
i = 5
MyString = LTrim(str(i))

Now MyString = "5"

 

[Richie(UK)]

Hi,

You might like to read about the various Type Conversion Functions (see the VBA Help files).

For example:

Sub test()
    Dim i As Integer, MyString As String
    
    i = 5
    MyString = CStr(i)
    MsgBox ":" & MyString
    
End Sub

HTH

 

[Yakov]

The easiest way I've found so far: use "CONCATENATE" Excel function, i.e.,

=CONCATENATE( B1, "" )

where B1 is a number.