How to get rid of Hyphens and spaces in result using dollartext switch
Hi, experts
I have a table with number 23,245.00 in cell C1
Using field switch Dollartext I write the below code outside the table (of course bookmarking the table first):
{=SUM(TABLE1 C1) \* DOLLARTEXT \* UPPER}
...and have an output:
TWENTY-FOUR THOUSAND TWO HUNDRED FORTY-FIVE AND 00/100
But I would like to see it without hyphens and spaces in uppercase like that:
TWENTYTHREETHOUSANDTWOHUNDREDFORTYFIVE AND 00/100
Is it possible?
|