Add a little space...

[hunibabidoll]

I'm sure this is a very simple thing to accomplish but it just isn't clicking today. I'm pulling data from two cells in one spreadsheet and placing it into one cell in another and need to add a space between the two.

oSheetOutput.Ce lls(i, 3).Value = oSheetInput.Cel ls(13, 6).Value & "," & oSheetInput.Cel ls(13, 4).Value

Is there a way to add a space after the comma? Now it's putting Doe,Jane... I'd like to make it Doe, Jane?

[Montravont]

just put a space between the "" after the comma

", "

or the "longer" way would be: "," & " "

[QVeen72]

Hi,

Try This :

[code=vb]
oSheetOutput.Ce lls(i, 3).Value = oSheetInput.Cel ls(13, 6).Value & ", " & oSheetInput.Cel ls(13, 4).Value
[/code]

Regards
Veena