concatenate the currency too

macropod · #5 12-12-2015, 05:50 PM

Quote:

Originally Posted by isasa74

At some point I used a formula to concatenate six cells, now two of them have a currency symbol along with the value (can be either USD or EUR) and I would need the symbol being concatenated as well.

Unless the cells contain text, the currency symbols are just cell formatting and are not part of the values themselves. That said, you should be able to retrieve the format if you change the way you're populating the array. For example, instead of:
.Cells(I, 2)
to return the value you might use:
.Cells(I, 2).Text
to return the formatted value.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)	SoonerLater	Mail Merge	1	09-30-2015 05:40 PM
how to concatenate text box on new slide	wichitawx	PowerPoint	5	05-19-2015 05:17 AM
Concatenate with @ symbol	anickles	Excel	2	02-06-2015 09:39 AM
Concatenate if in descending order	pgeorgilas	Excel Programming	2	12-10-2014 01:35 AM
If, move and concatenate in VBA	devcon	Excel Programming	0	07-04-2011 12:44 AM