Hi,
Can someone tell me how I can insert a space in the following string?
It's basically a concatenation of two cell but currently there is no gap when they are concatenated?
Thanks,
Jay3![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Can someone tell me how I can insert a space in the following string?
It's basically a concatenation of two cell but currently there is no gap when they are concatenated?
Code:
.Subject = wsData.Range("C" & aRow).Value & wsData.Range("E" & aRow).Value
Thanks,
Jay3