How can I add spaces in a concatenated string using a macro? Best regards
C Chip Pearson Sep 23, 2005 #2 Try something like Dim S As String S = Range("A1").Value & " " & Range("B1").Value -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Try something like Dim S As String S = Range("A1").Value & " " & Range("B1").Value -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com