Forum Discussion

Ben83's avatar
Ben83
Copper Contributor
May 21, 2019

How do I merge two currency cells, to create a range in excel?

Hi everyone, I am hoping someone might be able to help me. I have two columns denoting currency eg E1=$0, F1=$69 (converted to single decimal). I am attempting to merge the two together, and create a...
Excel
office 365
Jarodm's avatar
Jarodm
Copper Contributor
Sep 11, 2024

Ben83 

To get the formatting of the second part, add the following to the end of the merge fields just before the closing brackets Myprice \# “$,0.00”

 

Set your merge fields up as (Merge 1)-(Merge2)

That should give you the $0-$68.81

 

 

 

 

Resources