I need to concatenate several cells in calc. The contents of one of the cells must appear in subscript in the final output (the resulting string is engineering notation). Is there a way of specifying formatting for parts of a string?
Unfortunately, the return value of a user defined function - a string, just a string without any formatting options. However, you can create value in a cell by the procedure. In this case you can processing cell with property Text - including formatting arbitrary part thereof.
Related question with answer: Subscript based on cell value