Forum Discussion
Concatenate and keeping the currency formula
Is there a way to concatenate and keep the currency formula at the same time. I have to list a dollar range from $25- $10,000 in $50 increments. I've tried to copy the numbers down Excel in 2 columns then concatentate, but it looses the "$" symbol and the ",". Any suggestions on how to make a dollar range easier than actual writing each row.
Thank you
Hi Lisa,
To concatenate convert numbers to text like
=TEXT(A1,"$#,##0") & " - " & TEXT(B1,"$#,##0")
or FlashFill could work depends on how your data is structured
- Thank you Sergei, that worked. :)
