Single quote coming automatically

[satyadev]

Hi

I am trying to concatenate a number value with string and setting the result to a cell value. It was adding a single quote at the start automatically and only visible from formula bar. I dont want to have this single quote and i really dont understand from where it is getting appended. kindly help me.

Regards
Satyadev

 

[My Aswer Is This]

Try:

=A1&" "&A2[SIZE=6]
[/SIZE]

Or try:

="Mary had a little "&A2

 

[satyadev]

Thanks for quick reply but it did not worked for me.

Kindly find below what i am doing.

importSheetCellValue = 1234
dataExtendValue = "-Do"

ThisWorkbook.Sheets("Import").Cells(iRow, importSheetColumn).Value = CStr(importSheetCellValue) & " " & CStr(dataExtendValue)