Thread: [Solved] concatenate the currency too
View Single Post
 
Old 12-13-2015, 12:27 PM
isasa74 isasa74 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Dec 2015
Posts: 12
isasa74 is on a distinguished road
Default

Quote:
Originally Posted by charlesdh View Post
Hi,

Can you provide a file for us too look at?
@ charlesdh

hi thanks for your help, I uploaded the file with the code and some data as an example.

@ excelledsoftware

thanks you for the help, unfortunately I cannot simply concatenate a $ or € because they are variables the code must be able to read the format and report it accordingly in the concatenation

@ macropod

Thanks a lot for your interest, you suggestion is to technical for me, how would you exactly integrate that in the code that I posted please?
I didn't write the code myself entirely , I basically only added the two formulas: concatenation and Index/Match.
Attached Files
File Type: xlsm SAMPLE.xlsm (121.8 KB, 10 views)
Reply With Quote