BOLD WORDS IN CONCATENATE FORMULA

's Computer Specifications

Word Cell
My Name A1
Deepak A2

@CONCATENATE( A1"-"A2)

I WANT A RESULT Deepak shown BOLD

's Computer Specifications

On May 9, 7:17*am, dpk <dpk1...@gmail.com> wrote:
> Word * * * *Cell
> My Name *A1
> Deepak * * A2
>
> @CONCATENATE( A1"-"A2)
>
> I WANT A RESULT *Deepak shown BOLD

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenate and Bold	Pedro Costa	Microsoft Excel Worksheet Functions	3	1st Aug 2009 12:39 PM
How do I bold face text1 but not others in a concatenate string?	Jennifer	Microsoft Excel Misc	1	7th Aug 2008 12:31 PM
Concatenate 2 cells, and have one cell value display as bold?	Pierre	Microsoft Excel Worksheet Functions	3	26th Apr 2007 02:04 PM
Re: Bold words in a MsgBox	íÉÎÉÎ ðÁ×ÅÌ	Microsoft Access	0	23rd Jan 2005 04:46 PM
Bold Specific Words	MarkA	Microsoft Access VBA Modules	1	7th Aug 2003 12:15 AM