Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

BOLD WORDS IN CONCATENATE FORMULA

8,283 views
Skip to first unread message

dpk

unread,
May 9, 2011, 8:17:05 AM5/9/11
to
Word Cell
My Name A1
Deepak A2


@CONCATENATE( A1"-"A2)

I WANT A RESULT Deepak shown BOLD

Ron Rosenfeld

unread,
May 9, 2011, 1:03:45 PM5/9/11
to

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.

Don Guillett

unread,
May 10, 2011, 8:41:26 AM5/10/11
to

Sub putemtogetherandbold()
mybreak = Len(Range("a1")) + 1
Range("a3") = Range("a1") & "-" & Range("a2")
Range("a3").Characters(mybreak, 256).Font.Bold = True
End Sub

0 new messages