sobrien1234
Board Regular
- Joined
- May 10, 2016
- Messages
- 175
- Office Version
- 365
- Platform
- Windows
I want to concatenate 2 $ amounts but I lose the $ and the , in between the numbers. For example:
A1 = $100,000
B1 = $200,000
C1 = concatenate (a1," & ",B1)
The result I get is
100000 & 200000
So I lose the $ and the commas. Any suggestions?
thanks
A1 = $100,000
B1 = $200,000
C1 = concatenate (a1," & ",B1)
The result I get is
100000 & 200000
So I lose the $ and the commas. Any suggestions?
thanks