D dpk May 9, 2011 #1 Word Cell My Name A1 Deepak A2 @CONCATENATE( A1"-"A2) I WANT A RESULT Deepak shown BOLD
D Don Guillett May 10, 2011 #2 Word Cell My Name A1 Deepak A2 @CONCATENATE( A1"-"A2) I WANT A RESULT Deepak shown BOLD Click to expand... Sub putemtogetherandbold() mybreak = Len(Range("a1")) + 1 Range("a3") = Range("a1") & "-" & Range("a2") Range("a3").Characters(mybreak, 256).Font.Bold = True End Sub
Word Cell My Name A1 Deepak A2 @CONCATENATE( A1"-"A2) I WANT A RESULT Deepak shown BOLD Click to expand... Sub putemtogetherandbold() mybreak = Len(Range("a1")) + 1 Range("a3") = Range("a1") & "-" & Range("a2") Range("a3").Characters(mybreak, 256).Font.Bold = True End Sub
