Word Cell My Name A1 Deepak A2 @CONCATENATE( A1"-"A2) I WANT A RESULT Deepak shown BOLD
D dpk May 9, 2011 #1 Word Cell My Name A1 Deepak A2 @CONCATENATE( A1"-"A2) I WANT A RESULT Deepak shown BOLD
R Ron Rosenfeld May 9, 2011 #2 Word Cell My Name A1 Deepak A2 @CONCATENATE( A1"-"A2) I WANT A RESULT Deepak shown BOLD Click to expand... You will need to convert this to text first. It can be done with a macro, but more info is needed to suggest good design.
Word Cell My Name A1 Deepak A2 @CONCATENATE( A1"-"A2) I WANT A RESULT Deepak shown BOLD Click to expand... You will need to convert this to text first. It can be done with a macro, but more info is needed to suggest good design.
D Don Guillett May 10, 2011 #3 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
