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?

Not possible.

Cross-posted at: https://www.excelforum.com/word-form...xt-switch.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]