- Nov 14, 2005
- Office Version
I have two cells that have dollar values in them (J34 and J36). I have another cell (J38) that divides the two ($126 / $37 = 3.405405). I need to put in a cell a formula that shows the "Formula". Therefore I need to concatenate the values in the three fields. So I need a concatenate formula that would show "$126 / $37 = 3.405%"