Concatenate

csmax99 · Apr 19th, 2002, 07:59 AM

When using the concatenate function to assemble text strings and cell values, is there a way to show the formats resident in the referenced cells in the concatenated string?

Mark W. · Apr 19th, 2002, 08:02 AM

No, but there's nothing to prevent you for using the TEXT or DOLLAR worksheet functions (just to name a couple) to get the desired effect. For example...

=CONCATENATE(DOLLAR(A1,2)," on ",TEXT(B1,"mm/dd/yy"))

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

Apr 19th, 2002, 07:59 AM	#1
csmax99 New Member Join Date: Apr 2002 Posts: 1	When using the concatenate function to assemble text strings and cell values, is there a way to show the formats resident in the referenced cells in the concatenated string?

Apr 19th, 2002, 08:02 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	No, but there's nothing to prevent you for using the TEXT or DOLLAR worksheet functions (just to name a couple) to get the desired effect. For example... =CONCATENATE(DOLLAR(A1,2)," on ",TEXT(B1,"mm/dd/yy"))