Concatenate and Bolding Text

Feb 28th, 2002, 11:43 AM

I would like to bold the dollar amount only in a concatenation.

ie - You currently have a balance of $3,877.00

=CONCATENATE("You currently have a balance of "&DOLLAR(('Master Sheet'!G4),2))

Is is possible?

Thanks in advance

Paul B · Feb 28th, 2002, 01:41 PM

sorry miss read your post
Try =("You currently have a balance of "&'Master Sheet'!G4)

[ This Message was edited by: paul b on 2002-02-28 12:56 ]

etres · Mar 26th, 2002, 12:35 PM

Paul B, I thought you gave me the answer to:
If B1 is bold in size 10 and C1 is in italics in size 8, how to keep the formats when D1 has =Concatenate(B1,C1)

Can you help?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 11:43 AM	#1
Guest Posts: n/a	I would like to bold the dollar amount only in a concatenation. ie - You currently have a balance of $3,877.00 =CONCATENATE("You currently have a balance of "&DOLLAR(('Master Sheet'!G4),2)) Is is possible? Thanks in advance

Feb 28th, 2002, 01:41 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	sorry miss read your post Try =("You currently have a balance of "&'Master Sheet'!G4) [ This Message was edited by: paul b on 2002-02-28 12:56 ]

Mar 26th, 2002, 12:35 PM	#3
etres New Member Join Date: Mar 2002 Posts: 4	Paul B, I thought you gave me the answer to: If B1 is bold in size 10 and C1 is in italics in size 8, how to keep the formats when D1 has =Concatenate(B1,C1) Can you help?