Is it possible to nest SUBSTITUTE within an IF formula? I have a column that has a range of numbers in it that I want to combine in a TEXTJOIN string. However IF the number is a decimal, I need to substitute the decimal with an underscore. i.e. instead of 6.875 it needs to be 6_875. I'm not sure how to do it though. Can anyone help?
Thanks.
If you want more details, just let me know.
<tbody>
</tbody>
Thanks.
If you want more details, just let me know.
DRW | FACE | TEXTJOIN |
25 | 6.875 | 25_6_875 |
25 | 11.375 | 25_11_375 |
18A | 36 | 18A_36 |
<tbody>
</tbody>